Search Form and Subform

MadeCurler

enthusiastic pensioner
Local time
Today, 04:15
Joined
Dec 6, 2007
Messages
49
I have a main for with sub form. The main form has personal details and the sub form has list of fish catches per person. The main form has several fields like Name and Surname...I would like to put a a search facility on the main form based on Name and Surname fields that are linked to the onclick event of a command button. Something like this .....

DoCmd.OpenForm "FrmAnglersCatches", , , "[Angler First Name]=" & Me![TxtFName] & "and [Angler Surname]=" & Me![TxtSName]

But I can't get it to work
 

Users who are viewing this thread

Back
Top Bottom