subform refresh

[sir_dan_mitchell]

hey again people,

I have a subform that will look up certain data from another form when i select a certain field (name). Is there a way I can get the subform to automatically refresh as soon as I change the name in the form?

Thanks Dan

 

[Ally]

Pop Me.NameOfSubform.Requery in the OnCurrent event of the form.

 

[sir_dan_mitchell]

hey,

It doesnt appear to work! When I make a change to the name, the subform doesnt automatically update. However if i go to records - refresh, they do!

Dan

 

[sir_dan_mitchell]

ok, i have sorted that problem out now. I put that Me.NameOfSubform.Requery formula into the name field on change rather than on current, duno why it wouldnt work your original way.

I do however have another problem. I want to select name, address and tel no. from another form, but I want to store them in the existing form after looking them up (by name) using a combo box.

I want to do it this way as the data entry person shouldnt have to enter the whole persons details every time they look them up.

Do you understand what I mean?

Can you help?

Dan

 

[Ally]

Sorry - not quite sure what you mean.

You wouldn't actually "store" the name and address data in a form - it would be in a table. You could pull all the information you need into a query and then feed a form.

Can you explain a bit more?