Hi,
I'm looking for a bit of help with this problem. I'd like to retrieve a single record from a .mdb file straight into a user form.
For example the .mdb file has one table with 13 fields
On my user form I have 13 fields which correspond to the fields from the table.
Using a unique identifier (field 1) I'd like to retrieve that record straight into the fields on the user form. The user then has the option of making changes to any of those fields and then updating the corresponding record in the .mdb file.
I've seen plenty of examples of retrieving records to the worksheet but so far my searches have not found what I'm looking for above.
Any help with this query is appreciated!
Cheers
Mark
I'm looking for a bit of help with this problem. I'd like to retrieve a single record from a .mdb file straight into a user form.
For example the .mdb file has one table with 13 fields
On my user form I have 13 fields which correspond to the fields from the table.
Using a unique identifier (field 1) I'd like to retrieve that record straight into the fields on the user form. The user then has the option of making changes to any of those fields and then updating the corresponding record in the .mdb file.
I've seen plenty of examples of retrieving records to the worksheet but so far my searches have not found what I'm looking for above.
Any help with this query is appreciated!
Cheers
Mark