Access Forms

R

Rush

I have a master form, and in the master i want to be able
enter an ID number and another variable and click on a
button in the master form and on the next form that pops
up, i want it to display the record for that user id and
second variable, checking the id first, and the second
variable second. Can anyone help me? Thank you
 
K

Ken Snell [MVP]

The command button wizard will create the code for you to open a second
form. You then can modify that code to put a "WHERE" filter on the OpenForm
step that uses the "ID" value to filter the second form:

DoCmd.OpenForm "FormName", , , "IDFieldName = " &
Me.NameOfTextBoxWithIDNumber
 
Top