Olusesan-
That's what we're here for!
Yes, when you set the tab order for the form, you can set it to go to controls on the form, but if you have a Tab control, then that's probably the last control in your tab order. Within a Tab on the Tab control, you can only set the order for controls on that tab.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Olusesan Makinde
Sent: Wednesday, August 22, 2012 9:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Preventing movement to a new record when using a Combo box in header
John,
Terrific! You are more than a blessing. The power of a forum is just inexplicable. I have learnt so much from visiting various forums on MS Access and reading problems others have encountered.
I set the cycle property and that sorted out the movement between records.
I had attempted to set the next control for the last control on the first "page" tab but ran aground when I discovered the controls listed in the "tab order property box" when I select a page are limited to only the available controls on that page.
Am I leaving something out here?
Olusesan
________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, 22 August 2012, 14:25
Subject: RE: [MS_AccessPros] Preventing movement to a new record when using a Combo box in header
Oluesan-
Did you check your keyboard settings? Also check the Tab Order for your controls and make sure that the "next" control after the last one on the first "page" (tab) is the first control on the second tab. And finally, set the Cycle property of your form to Current Record.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com [mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Olusesan Makinde
Sent: Wednesday, August 22, 2012 7:27 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: Re: [MS_AccessPros] Preventing movement to a new record when using a Combo box in header
Thank you John.
I have a form that has multiple pages. I made a combo box in the header section to show me a specific record based on some previous data for providers I have entered into the database. Once I complete the daa entry on the first tab (page) and I hit enter, rather than move to the next tab, a new record for the first page comes up. I dont want that to happen so I want to limit the visibility/ data entry capacity to the record I select in the combo box.
Olusesan
________________________________
From: John Viescas <mailto:JohnV%40msn.com>
To: mailto:MS_Access_Professionals%40yahoogroups.com
Sent: Wednesday, 22 August 2012, 13:14
Subject: RE: [MS_AccessPros] Preventing movement to a new record when using a Combo box in header
Dear Olusesan-
Welcome to the group!
Please explain in more detail what you mean by multiple pages. Are you using
the Page Break control on a very long form, or are you using a Tab control? As
for what happens when you press Enter, take a look at how you have your keyboard
options set. In 2003 and earlier, it's in Tools / Options. In 2007 and later,
it's in Access Options / Advanced / Editing. The default for Move After Enter
is Next Field, but if you have it set to Next Record, then that's your problem.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: mailto:MS_Access_Professionals%40yahoogroups.com
[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of SESMAK
Sent: Wednesday, August 22, 2012 6:48 PM
To: mailto:MS_Access_Professionals%40yahoogroups.com
Subject: [MS_AccessPros] Preventing movement to a new record when using a Combo
box in header
Hi Everyone,
I am new to the group though quite been develoing MS Access databases for a
while.
I ran into a problem while trying to create a form that has multiple pages and
uses a combo box to select a specific record in the form.
Once the data on the first page is inputted and I press enter, the page
automatically changes. I have tried all sorts but not been able to find a
solution.
Is there anyone that has had such challenges in the past in-house?
Olusesan
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar