silly problem

[bigmac]

hi all can you help please I have a main form and what I am trying to do is open another form matching only records shown in a text box [text1] , I have a button to open the form so I need the vba so when I open the form it shows only what records have the same value as main form (datasheet view) , can you help please, I have tried macros but no joy

 

[RuralGuy]

Use the Where Condition argument of the OpenForm command to filter the next form's recordset.

 

[bigmac]

can you show me how please

 

[RuralGuy]

Sure, what is the name of the field in the RecordSource of the next form whose value you have in the [Text1] textbox?

 

[bigmac]

hi ruralguy , thanks for your help, I went online and googled the where condition and have found the solution , that you for your help

 

[RuralGuy]

Excellent! Thanks for posting back with your success.