Using recordsource code more then once on a open form

[smercer]

Hi all

I am having a problem with the coding recordsource. I can change the record source once but after that I can not. (it won't do anything, without even giving an error code) I have to resort to closing and re-loading the form again which is too slow.

Here is one of my coding to change a subform

Form_sfrm_Books_Descriptions_in_Store_Datasheet_Popup.RecordSource = "qry_Filter_in_popup_For_Book_Description"

Does anyone have any Ideas?


Thanks in advance

 

[KenHigg]

Are you doing a requery after you change the record source?

ken

 

[smercer]

Are you doing a requery after you change the record source?

ken

Hi Ken

I think I overlooked the obvious. thanks for the help.

 

[KenHigg]

been there...