Pass selected value in list to text box

casper

Registered User.
Local time
Today, 00:50
Joined
Aug 26, 2006
Messages
12
I have two forms - Notes and JobLookup
Notes contains a number of text boxes for entering data, one of them being for Job No. Beside it is a link to the form JobLookup. This form contains a simple listbox that lists all the job no. Is it possible to pass the selected job no from this list to the text box on the Notes form?

Hope this makes sense :)

Michael
 
You can do this several ways;

You can have the list box result (what you select) bound to a Control source on
the form.

You can have an unbound list box that when an item is selected it will update either a bound or unbound (or both) text box on the form.

Post back with your choice and I will send you a sample.
 
Sorry it's taken so long to respond. I've attached an image of how it appears at the moment: And this is what I want it to do :)
When 'lookup' is clicked on the left form the right lookup form appears.
The user then scrolls down through the list of jobs and highlights one by clicking on it. Then clicks select.
Then selected value is then transfered to the first text box (Job No.) on the left form.

Hope this makes sense
 

Attachments

  • Forms.jpg
    Forms.jpg
    66.7 KB · Views: 402
Sorted the answer :)
In the code for the select button I added

Forms!notes!txtJobNo.Text = Me.lstJobs.Value

and it works :)
 

Users who are viewing this thread

Back
Top Bottom