Access Forms

  • Thread starter Thread starter Rush
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Only enter a certain number of values in a text box? Access 2000 5
Create a button to find the next record 6
How to calculate the age in a particular month? 0
transfer a field using button 1
DLookUp 1
Sub form question 5
Form 3
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top