PDA

View Full Version : Search Function in a User Form



jason_kelly
07-22-2010, 05:17 PM
Hello,

I would like seek your help in creating a user form search function.

in the database are 3 fields

Received Date | File Number | Assigned To


For example, let's say if I wanted to search just the received date, the search results would then populate my form with all that values for that row (Received Date, File Number and the Assigned To)

I would also like the same search functionality for the other 2 fields (File Number and Assigned To) as well, so if I searched by file number/Assigned to, it would populate my form with the Received date, File number and the Assigned to values with the data in that row.

You're help with this is greatly appreciated.

Much thanks and appreciation.

Cheers,

Jason

mdmackillop
07-24-2010, 02:08 AM
Hi Jason,
Welcome to VBAX.
Can you post a small sample file with your form (Manage Attachments in Go Advanced reply section)

bkgashok
07-24-2010, 07:32 AM
pls elaborate your query...