How to select value from combo list thru lookup table and update different table.

[sensreview]

Hello,

I need help in selecting a value from combo list thru one lookup table and update different table on MS access form.

For eg; I have a lookup table of usernames,

I need to use this lookup table in all my other forms to update different table selecting the username from my lookup table.

I tried Docmd.runsql but unable to succeed.

thanks in advance,
Senthil

[Rabbit]

What table are you trying to update? And what data are you trying to update in the table?

Have you tried making a query? Does that work?

[sensreview]

Hi,

I have 2 tables,

1. Userlookup table
field: username
2. Project data table
field 1: project name
field 2: username
field 3: start date
field 4: end date

i created a form to fill the "project data table", i wished to have a selection option (like a drop down menu) in the username field. so i made the row source to select the username list from the "userlookup table"

but when i creat a command button for adding the values to : "project data
table " it is not working.

Senthil

[Rabbit]

Hi,

I have 2 tables,

1. Userlookup table
field: username
2. Project data table
field 1: project name
field 2: username
field 3: start date
field 4: end date

i created a form to fill the "project data table", i wished to have a selection option (like a drop down menu) in the username field. so i made the row source to select the username list from the "userlookup table"

but when i creat a command button for adding the values to : "project data
table " it is not working.

Senthil

I assume your form is bound to your table? Just set the control source of the combo box (drop down menu) to the username field of your project table and you don't need a button to update the records, it'll update automatically.

[sensreview]

I assume your form is bound to your table? Just set the control source of the combo box (drop down menu) to the username field of your project table and you don't need a button to update the records, it'll update automatically.

Thanks it works fine.

:-)

[Rabbit]

No problem. Glad I could help.