List Box Item Select

[Sharon Hague]

Hi

I have created a database which we are using as a telephone log. I have then created a form called "Telephone Log Amend - Select" which shows a list box comprising of 4 colums drawing the information from the main table - Call no which is the primary key, Date, Time & Caller. I have created another form called "telephone log amend - full" which holds all the details relating to that form.

I want to be able to select an entry on the "telephone log amend - select" form from the list and it open that same record in the "telephone log amend - full" for me to be able to edit that entry.

I have created a macro to open the form "telephone log amend - full" "on click" in the "telephone log amend - select" form which it does take me to the form, however it does not take me to the call which has been selected from the list box of form "telephone log amend - select"

Any ideas?

 

[Robert Dunstan]

Hi Sharon

In the underlying query for your form "telephone log amend - full" trying settig the cirteria for your primary key to =[Forms]![Telephone Log Amend - Select]![yourListBoxControlName]

See if that works

HTH
Rob

 

[Sharon Hague]

Hi Rob

Thanks it's worked a treat.

 

[Robert Dunstan]

Glad I could help