Sandra Smith
asked on
Open bound form without a record showing ACCESS 2010 form
I have a form that is bound to underlying records. However, it is single record presentation as there is a lot of data on each record and I only want to show record that user selects from a combobox. however, when it opens, it always opens on the first record. how can I get it to open without showing a record until the user makes their selection? I do not want them to inadvertently change data on the wrong record.
use a Main/subForm combination
place the unbound combo box in the main form
set the master/child link for the subform to
master link me.parent.[name of combo]
child link [use the bound column of the combo box; this could be the id field of your record]
place the unbound combo box in the main form
set the master/child link for the subform to
master link me.parent.[name of combo]
child link [use the bound column of the combo box; this could be the id field of your record]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked as I do not want data entry and there are no parent/child forms involved. I just want it not to show a record for them form and this did the trick.
Jim.