Access to Unbound controls

[Sathyab]

Hi,

I have a Transaction ID (TransID), Client ID and Client Name.
To perform a transaction, you need to choose a client name and follow up with some other actions.

TblTransaction
-------------------
TransID autonumber - pkey
ClientID
...

Client Name is retrieved from TblClient using the foreign key ClientID.
Client Name is put up on the form as a unbound drop down control. Source - query retrieving all the client names.

Problem: Once data is added, while traversing through records, the Client Name drop down does not reflect names corresponding to ClientID.
For the first instance it is possible to use the Form load event to display the right client name (for the client id of the first transaction.) But after that ... have not been able to fetch and display the right record...

1)TblTransaction
--------------------
T0001 CL0002
T0002 CL0014
T0003 CL0001
...

2) TblClient
----------------------
CL0001 Reggie
CL0002 Juggie
....

While displaying on form...
Form view 1
----------------
T0001 CL0002 Reggie This works...

Form View 2
-----------------
T0002 CL00014 Reggie (heres where i need to display the right client name...)

...how do I go about it???

 

[Parker]

Hi,

Hi Sathyab

OOH Errr --------- Lotsa numbers--------I don't like numbers, especially first thing in the morning. Unless, that is, they have a £ in front

First thing;

Have your list box display both ClientID & ClientName.

Have the form display the record relevant to the criteria in your list box.

In the forms 'onupdate' event do a refresh.

That way you will always display the right information.

HTH

 

[Sathyab]

Answering to Pat Hartman

Answering to Pat Hartman:
Display part works fine when I join multiple tables.
But try to add new records through the same form, it tries to add new records to the joined tables too. Follows up with errors!