Code for form operation 1

[hwmueller]

Hi

I have question concerning the writing of code for an operation within a form.

The database has a form which requires the entry of various info and one of these fields is a staff number. The selection of the responsible staff member's staff number results in various other fields being auto-completed. My problem is that when clicking the drop-down button on the staff ID field one only sees the numbers and for a person not familiar with which staff member has which number a usless prospect. How do I make a 'block' or similar appear which lists the staff member numbers with the corresponding names???

Thanks for your help

Hans

 

[THoey]

You can use a query to load your listbox with both the member name and the number, but set the column width of the number portion to 0 width, making it invisible. That way all the user sees is names. But then when they select a value, you could use the second field as your bound column.

Hope that points you in the right direction...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[hwmueller]

Hi Terry

I understand what you are saying and have tried it but am not coming right! What would the query look like and how do I link this to the form?

Thanks

Hans

 

[THoey]

Are you talking about the query for the listbox or the query to fill the form after the selection has been made?

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[hwmueller]

Terry

sorry! I am a beginner and thus probably need guidance on both!

Thanks

Hans