data entry form with pre-existing info
- Thread starter tubar
- Start date
RossWindows
Que?
- Local time
- Yesterday, 21:29
- Joined
- Feb 25, 2008
- Messages
- 410
You can accomplish this by changing the location field on the input form to a textbox, then set it's default value to [Forms]![form1]![location name]
Before you do that though, I would rename all fields, tables and objects so they do not contain spaces in their names and choose a naming convention that you will remember.
E.g.
[Forms]![form1]![location name]
will become
[Forms]![frmLocations]![txtLocationName]
and Table1 will become tblLocations etc.
Before you do that though, I would rename all fields, tables and objects so they do not contain spaces in their names and choose a naming convention that you will remember.
E.g.
[Forms]![form1]![location name]
will become
[Forms]![frmLocations]![txtLocationName]
and Table1 will become tblLocations etc.
