Subform asking for Id

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I have main form, subform (frm1), from my subform(frm2) I call another
form(frm3). When frm3 opens, It opens the form and then it asks for the ID
before populating the form with data. How can I eliminate this step. I want
form 3 to open with the data and not ask me for the ID. thank you.
 
Pass the ID value in the DoCmd.OpenForm action (I assume this is how you're
opening the third form?), using the fourth argument of the OpenForm action.

Then remove the WHERE clause from the third form's Record Source query that
is on the ID field.
 
Back
Top