Subform view

Hi all,

I have one subform in a main form which is working fine with the exception 
of how it looks whenever I open the main form. Whenever I open my main form, 
the view of the subform is always in the middle of the form. I need to scroll 
up to see the top of my subform. The subform does contain a lot of fields so 
I understand my users will need to use scroll bars. But is there anyway to 
start the view at the top of the subform? It is highly annoying to have to 
scroll up every time the record changes in order to start at the top of the 
subform. Any insight is greatly appreciated.

Thanks!
LaurenM
0
Utf
10/29/2007 3:16:02 PM
access.forms 6864 articles. 2 followers. Follow

2 Replies
593 Views

Similar Articles

[PageSpeed] 21

Hello LaurenM.

"LaurenM" wrote:
> I have one subform in a main form which is working fine with the
> exception of how it looks whenever I open the main form. Whenever
> I open my main form, the view of the subform is always in the
> middle of the form. I need to scroll up to see the top of my
> subform. The subform does contain a lot of fields so I understand
> my users will need to use scroll bars. But is there anyway to start
> the view at the top of the subform? It is highly annoying to have
> to scroll up every time the record changes in order to start at the
> top of the subform. Any insight is greatly appreciated.

You probably should configure the tab order of the subform such that
a control at the top of your subform gets the focus first.

-- 
Regards,
Wolfgang 


0
Wolfgang
10/29/2007 7:31:00 PM
Brilliant!! That worked perfectly! Thanks so much!!!

LaurenM

"Wolfgang Kais" wrote:

> Hello LaurenM.
> 
> "LaurenM" wrote:
> > I have one subform in a main form which is working fine with the
> > exception of how it looks whenever I open the main form. Whenever
> > I open my main form, the view of the subform is always in the
> > middle of the form. I need to scroll up to see the top of my
> > subform. The subform does contain a lot of fields so I understand
> > my users will need to use scroll bars. But is there anyway to start
> > the view at the top of the subform? It is highly annoying to have
> > to scroll up every time the record changes in order to start at the
> > top of the subform. Any insight is greatly appreciated.
> 
> You probably should configure the tab order of the subform such that
> a control at the top of your subform gets the focus first.
> 
> -- 
> Regards,
> Wolfgang 
> 
> 
> 
0
Utf
10/29/2007 9:00:00 PM
Reply:

Similar Artilces:

Customize Activities Views
Is there any way of customizing the Activities view? Every other view seems to be customizable except activities. Thanks, Not in the current release of CRM ie 1.0 and 1.2. We are expecting to see the ability to customise Activity views in version 2.0. One way to get what you need is to create your own activity view in asp.net and using the CRM SDK. <anonymous@discussions.microsoft.com> wrote in message news:29b8701c46681$04162130$a601280a@phx.gbl... > Is there any way of customizing the Activities view? > Every other view seems to be customizable except > activities. >...

using auto filter and custom views
i am using both the autofilter command and custom views simultaneously. the custom views are set up using criteria specified with the filters. i am using filter criteria in 1 column only. in the custom views, i have checked both the "print settings" box and "hidden rows, columns, and filter settings" box to include in view. in order to delete a column or columns in the spreadsheet i must turn off the auto filter command. once i turn it back on, my custom views "forgets" the criteria in the filter and i must reset the custom views. the hidden columns and...

Drop down menu from subform
I was wondering if anyone can help me with this one as i am really loosing the will to live. I have a main form which i wish to log PCB numbers. On that form i have two subform's, one which is called Board Information and one that is called Software Information. I have got the Board Information subform to link not a problem to the main record and only show the board revisions for the main record, but then when it comes to the software subform i hit this problem. I would like a drop down field on the software subform to select the board revision number from the Board Information subform. ...

populating a subform
My DB has three linked tables, many forms and reports. I am building a new form and i need a sub form to populate when I enter data in a text box on the main form. both forms get thier info from the same table but there could be three or four sets of records in the sub form that would be identified by the field in the main form. ex: main form has a text box for info 'a' there is fields b,c,d,& e in the sub form. the table would look something like (row 1) "a" = 234 B=456 c = 789 d=101112 e = 131415 (row 2) "a" =234 b= 171819 c = 212239 d= 333425 e=44454...

Login Error
I am seeing a series of error messages when users attempt to log in through a terminal server to GP: SQL Error: 3701 [Microsoft][SQL Native Client][SQL Server] Cannot drop the view 'EBSGL20001V', because it does not exist or you do not have permission. SQL Error: 2760 [Microsoft][SQL Native Client][SQL Server] The specified schema name "dbo" either does not exist or you do not have permission to use it. Thank you in advance! Craig You may want to run the GRANT.SQL utility script provided with Microsoft Dynamics GP on all your company and DYNAMICS databases. Best ...

Allow customization of relationship view columns in the account
When viewing the "Relationships" section for an account, we cannot change the columns displayed in customizing and are limited to Party 1 Role 1 Party 2 Role 2 which is very limiting. It would be usefult to be able to add additional columns to better descripe the relationships based on fields maintained in the account or contact record. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follo...

How to view a graphic (bmp/jpg etc) file as incorporated in Outlook XP
This is a multi-part message in MIME format. ------=_NextPart_000_0150_01C3CED8.36A1D860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Ref: How to view a graphic (bmp/jpg etc) file as incorporated in Outlook = XP In Outlook Express, when an email arrives with a graphic file (JPG, BMP, = TIF, etc.), I can view it straight from the email message as an = incorporated part of same, without having to open each attachements. I can I get the same results with Outlook 2000 and Outlook XP? Thanks Regards Yossi ------=_NextPart_000_0150...

Cannot edit fields on a subform?. It's sending me nuts!
I have a Subform based on a query, which is based on at table. The query contains a calculated function, for some reason I cannot edit the fields. Can someome tell me why this may be so?. everything appears to be in order regarding the various properties relating to editing. Data Entry - No Allow Additions - Yes Allow Deletetions - Yes Allow Filters - Yes Record Locks - No Locks I'm baffled, and frustrated... If you run the query by itself, is it updatable? If it isn't, the form won't be either. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-...

Default View Includes Preview Pane On
I am using O2K with all updates on 2 different computers, a laptop with Win2K and a desktop with WinXP Pro. Both show the same behavior. When I create a new folder, the View setting has the preview pane ON. I don't like to use the preview pane for my mail and always turn OFF this view. Is there any way to change this default behavior? I have not been able to find any way to make this change, and since I use lots of folders and frequently create new ones it is a real nuisance to have to change the view setting for every new folder I create. Any help will be greatly appreciated! Alan Ha...

View life as a continuous learning experience.
View life as a continuous learning experience. http://smallbusinessebooks.googlepages.com/ http://smallbusiness-ebooks.blogspot.com/ ...

Insufficient permissions to view contents of folder
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC Email Client: pop After installing Leopard and then reinstalling Tiger, Entourage gives me the message &quot;You don't have sufficient permissions to view contents of this folder&quot;, but it does not say which folder. As root I've given myself ownership of all the folders and files in the Microsoft User Data folder and the Microsoft Entourage Archive folder in my home user documents folder, but the message still appears on launch of Entourage. What other folders does Entourage use? What do I need ...

Resource Assignments View Filtered on Booked Type Field
I have a project that has been cancelled part way through. To deal with this, I've set the Booked Type field to be proposed for all resources in this project. This works great in that the tasks from this project no longer appear in the resources My Tasks view but they do still appear in the Resource Assignments views I have and I don't seem to be able to filter Resource Assignnments on Booked Type. Is that possible or is there another way I should be going about what I want to achieve? Which is to keep a copy of the cancelled projects plan in Project Server for refere...

View one record at a time in a report.
I am new to access. I created a report from a table using the wizard. When I view the report, I only want to see one given record at a time - not all records. How do I do this? Thank you Ron The easiest way is to start from a form, where you bring up the record you want to see. Then put a command button on the form, to open the report to just that one record. Here's the code you need for the command button: Print the record in the form at: http://allenbrowne.com/casu-15.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne...

Loading subform with data from main form
I thought this would do it: I put this in the before insert of the subform: Me!txtJobID = [Forms]![frmInvoice]![txtJobID] frmInvoice is the main form. What can I do differently to make this work? Thanks. SAC wrote: >I thought this would do it: > >I put this in the before insert of the subform: > >Me!txtJobID = [Forms]![frmInvoice]![txtJobID] > >frmInvoice is the main form. > >What can I do differently to make this work? You could use that code in the BeforeUpdate event, but this whole exercise would be automatic if you set the subform control's Link M...

View Excel Cells in Color
When a fill with a color an excel cell, the screen didnt show me the color ive apply to cell. I have to click the preliminary presentation icon to see the color i ve applyed. Is this an excell error? Why should i do to fix it? The first thing I'd suggest is posting your question in the Excel newsgroup instead of Publisher. -- JoAnn Paules MVP Microsoft [Publisher] "andres torres via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in message news:c282191dd452428491c39a28c93cb703@OfficeKB.com... > When a fill with a color an excel cell, the screen didnt show me th...

Problem viewing 2007pptx file in 2003 involving links
I created a presentation in ppt2007 (so it's saved as .pptx). In it, I have a link to a slide that is hidden. So, you click the link on slide 10, which takes you to slide 11 which is hidden. When you click anywhere on slide 11, it takes you back to slide 10. When you click anywhere on slide 10 (other than the link), it takes you forward to slide 13. When I save the presentation down to .ppt, or even when I package to CD, and then view it on a machine without ppt2007 installed, the link does not work. Slide 11 is still hidden when viewing it on ppt2003, but the link on slide ...

intermittent problem bookmarking record to subform of itself
This code always works at first, but then goes amiss. While the symptoms are consistent, I haven't found the circumstances to consistently trigger the problem. However once triggered, the problem happens consistently until the form is closed and re-opened. Here's the goal: I have a form showing one record at a time. It has a subform showing the same data in a datasheet. When I advance a record on the parent form, the subform should highlight the same record displayed on the parent. When I click a record in the subform, the parent form should jump to the same re...

How do I set the view to default to last modified
I like my files to always be in last modified order with the most recently saved file at the top of the list. In Excel 2000 I set the order in the open window and from then on all files in all folders were in the correct order. Recently I changed to Excel 2003. Since then I have had problems. I change the vies as before but each time i close the application it reverts to sorting by name - in alphabetical order. Any suggections? ...

Subform sort order problem
I have a form/subform. They are linked on the field 'cnum'. The fields in the table 'Received' which is what the subform is bound to are: Cnum Ldate Lbs Furniture Clothes Council The 'OrderBy' = received.ldate DESC and 'OrderByOnLoad' = yes However, when subform opens the records are sorted in ascending order. To check this I put the following into the 'Current' event of the form: Debug.Print Me.OrderBy, Me.OrderByOn, Me.OrderByOnLoad The results of this are: ldate DESC False True ldate DESC False True ldate DESC Fal...

Can't view .TIFF after install of Offcie 2002 SP3
Has anyone seen this senario: Could view tiff and embedded tiffs in documents in Office 2002 SP2 but not after the install of Office 2002 SP3 ...

portfolio manager view problem
It seems that I created a portfolio manager view that is corrupted and now every time I try to go to portfolio manager in Money 06 or 07, they abend. How can I go back to the default view. Thanks in advance. In microsoft.public.money, scsppc wrote: >It seems that I created a portfolio manager view that is corrupted and now >every time I try to go to portfolio manager in Money 06 or 07, they abend. >How can I go back to the default view. First, save an extra copy of a backup that pre-dates the problem. You may also want to increase the number of backups that Money 2007 keeps fo...

Verify that looking at DATA of SQL SERVER VIEW will be read-only
We want to start allowing our users to have ODC files to connect to and look at data in SQL SERVER VIEWS. I want to make sure that the users will only ever be able to look at this data and not actually change the back-end SQL data. Thanks for any clarification you can give! Our MIS Dept. has given me Read-only rights to one of our SQL databases. I can extract any data I wish with MsQuery, and process it in Excel. I can not change anything in the database itself. hth Vaya con Dios, Chuck, CABGx3 "Steve Z" wrote: > We want to start allowing our users to have ODC files ...

Reminder list view
Is there a way to change the view for reminders in Outlook XP. Our new XP users are asking for reminders to pop-up individually like in Outlook98, not as a list in one window. Registry hacks are welcome. Nope. -- Patricia Cardoza Outlook MVP Author - Special Edition Using Microsoft Office Outlook 2003 Lead Author - Access 2003 VBA Programmer's Reference Author - Absolute Beginner's Guide to Microsoft OneNote 2003 http://blogs.officezealot.com/cardoza http://www.cardozasolutions.com "London Canada" <London Canada@discussions.microsoft.com> wrote in message news:1...

Viewing Tabs
In Office 2007 how can I view the tabs at the bottom of a worksheet Hi Karen Office button>Excel options....Advanced See display options for this workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "karen" <karen@discussions.microsoft.com> wrote in message news:0BE206C7-62DF-40DA-AC1F-173D16DAF429@microsoft.com... > In Office 2007 how can I view the tabs at the bottom of a worksheet ...

Shared tasks views
Hello, I am running Outlook 2002 sp2 with exchange 2003 server. We have share out a task list for the department. The view is obviously the task view. We would like to have the ability to view the tasks in a calendar. I have two questions, 1.can we import, export, (whatever) the current tasks into a calendar. Then we can share the calendar? 2. Just change the current task list into calendar view? Any assistance is appreciated. Steve -- Stephen Tornari Senior Technical Specialist ...