I have a site profile table with many columns. For data entry I will require 3-4 forms to be able to enter all of the data, with each page displaying the key. I want to have a button on each page to proceeed to the next. This is not a 1 to many situation. What code do I put in the key field text box on the 2nd through N pages to display the same non updateable autonumber key value.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Referring to another form 2
- Thread starter gtobey
- Start date
-
1
- #2
You could create a Global variable and put it in a Public Module like so
Global MyAutoNumber
Then in each forms "On_Activate" event have this code
Me![key field text box]
Ok so each time you move to another form no matter which direction it is the form will get this number.
Now this number is put there from the "After_Update" event on the first forms Text box
MyAutoNumber = Me![Key field on first form]
DougP, MCP
Global MyAutoNumber
Then in each forms "On_Activate" event have this code
Me![key field text box]
Ok so each time you move to another form no matter which direction it is the form will get this number.
Now this number is put there from the "After_Update" event on the first forms Text box
MyAutoNumber = Me![Key field on first form]
DougP, MCP
-
1
- #3
A completely different solution to the problem at heart. Use the Tab Control Tool in form design (Not tab order) so that way you have many 'sheets' for data entry and viewing. Its all considered one form, but you can contain alot more info on 1 screen w/o scrolling. The effect is silimiar to going to Tools, Options in any MS product...
- Status
Similar threads
