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 <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.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]
Tidak ada komentar:
Posting Komentar