Automatic Propagation 1

[PharmaFun]

Hello,

I need help yet again. I have one form where I type in an ID number, name, date of birth, etc. Now I have another form where I have a pulldown menu that shows the ID numbers already entered in the first form. How can I set it so the name and date of birth fields in the second form are matched to the ID selected and therefore to the values in the first form?

Thanks,
PharmaFun

 

[Rolliee]

I would do this with VB code.

Using the click event on the combobox enter the following code

private sub YourCombo_click()
DIM rs as DAO.recordset
set rs = me.recordsetclone
rs.movelast
rs.movefirst
do while not rs.eof
if rs("ID&quot = me.MyCombo then
me.bookmark = rs.bookmark
exit do
endif
rs.movenext
loop

rs.close
set rs = nothing

exit sub


rollie@bwsys.net

Remember out there to reward the troops that help you with Stars.