Select record

[StaphAreus]

I have a form with a sub form

what I want to be able to do is use the main form and search on postcode surname and display the records that match in the subform and then allow the user to select which record to add additional data to

ahhhhhhhhhhhhhhhhhhhhh

 

[Ashfaque]

goto design mode of your main form, create one search combo box based on the postcode surname field from the table and place it on main form. Save and Close form. When you run main form next time, you may select the postcode from combo that will bring the data into your sub-form for further actions.

HTH

With kind regards,
Ashfaque