What code needed to select record from ((Main form)) in (sub form Datasheet)

V

vb

Link the Sub Form to the main form with Employee Id. Put
a hidden field in the main form with control source as
Employee Id. In the AfterUpdate event of the dd box. I am
not sure whether you did this. In this way when the
Employee Id from the dd box try inserting the code to
open the form with EmployeeId in the Where clause.

HTH
vb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Update a date field in sub-form from dates fields on main form 1
showing a subform based on the main form 5
Pick List for Combo Box & Displaying Old data 0
Sub Form to Unbound main form control 2
Launching a Form to Another Form to Create a New Record 12
Private Sub not working on main form 1
Display data based on selction from combo box 10

Top