Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

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.
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Set the dataentry property to true

Jim.
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]
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandra Smith

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.