Tim L
Registered User.
- Local time
- Today, 14:47
- Joined
- Sep 6, 2002
- Messages
- 414
How can I go about accessing records in a table/query from within VBA? I would not be using modules as I don't know how they work, it would be some code attached to a control on a form.
Also, the table/query being accessed would not be the one that is the Record Source of the form on which the control is situated.
I would want to locate a particular record and then be able to access a particular field.
I'm trying to be as broad reaching in my description here because I don't have that much experience with VBA (for Access 2k, using Access XP) and need to keep things simple...
If there's a thread in here that deals with what I need I can't find it but then there's a lot of information and I'm probably using the wrong search criteria...
Anyway, thanks in advance for any useful replies.
Tim
Also, the table/query being accessed would not be the one that is the Record Source of the form on which the control is situated.
I would want to locate a particular record and then be able to access a particular field.
I'm trying to be as broad reaching in my description here because I don't have that much experience with VBA (for Access 2k, using Access XP) and need to keep things simple...
If there's a thread in here that deals with what I need I can't find it but then there's a lot of information and I'm probably using the wrong search criteria...
Anyway, thanks in advance for any useful replies.
Tim