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
DoCmd.OpenForm "FrmAnglersCatches", , , "[Angler First Name]=" & Me![TxtFName] & "and [Angler Surname]=" & Me![TxtSName]
But I can't get it to work