Refreshing form 1

[mrblonde]

Hi,
I know this isn't technically refreshing but this is what I am trying to accomplish. I have a form that is based off of three tables, all with the same primary key. I want to create a combo box (which I did) for the primary key. I can go into the drop down and select from the data, but the other fields do not follow suit. Does anyone know what I am missing here?

 

[ghubbell]

A refreshing question!
In VB code in the "after update" event of your combo you would have to have something like:

Me.NameOfSubFormAsSeenByMainForm.Requery

Just like that!
Gord
ghubbell@total.net

 

[ghubbell]

Back up a sec Gord!, If your combo is Not bound and you're just using it to "filter" the records on one form? Then in it's after update event try:

Me.SomeFieldWhereYouWantToLook.SetFocus
DoCmd.FindRecord Me.NameOfTheCombo, acEntire, False, acDown, False, acCurrent

Still a refreshing question~quasi refreshing answer! Gord
ghubbell@total.net