Emohawk
What a wicked mullet...
- Local time
- Today, 03:47
- Joined
- Mar 14, 2002
- Messages
- 79
This is probably an easy one but I can't seem to work it out.
I have a combo box linked to a table containing [Customer Name] and a [Serial Number] an autonumber key.
On the same form are two subforms, GBS Clients and ACBS Clients, linked to the main form via the [Serial Number].
My problem is this, when I open the GBS Clients and ACBS Clients subforms they jump straight to the first [Serial Number] in their respective tables while the main form opens up the first [Customer Name] record.
I need to syncronise this so that the subforms show the corresponding records for the opening record on the Form.
FYI - A record does not have to exist in either GBS Clients or ACBS Clients for there to be a Customer Name
Cheers
I have a combo box linked to a table containing [Customer Name] and a [Serial Number] an autonumber key.
On the same form are two subforms, GBS Clients and ACBS Clients, linked to the main form via the [Serial Number].
My problem is this, when I open the GBS Clients and ACBS Clients subforms they jump straight to the first [Serial Number] in their respective tables while the main form opens up the first [Customer Name] record.
I need to syncronise this so that the subforms show the corresponding records for the opening record on the Form.
FYI - A record does not have to exist in either GBS Clients or ACBS Clients for there to be a Customer Name
Cheers