View Single Post
  #1 (permalink)  
Old July 10th, 2003, 11:36 PM
bear1138 bear1138 is offline
Registered User
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to bear1138
Default Two data items from a populated dropdown menu

DreamweaverMX v6.1, Access2002

On a form, I am populating a dropdown menu from a datafile. The datafile contains 2 text fields
'Position' and 'PositionCode'.

I would like to know how to get values from both fields when a user make a selection from the dropdown menu.
When the user selects a 'Position' from the dropdown, I want to input it and the PositionCode into a third table.

The best I've gotten so far is both fields together and entered into the third table. e.g. Instructor Pilot,55
Before I go down the road of trying to split the field into two separate items I'd like to know if there is a simpler
way to do this. It seems like a common thing to do but after asking on four forums I still don't have a solution.

Any Ideas Would Be Appreciated

Reply With Quote