By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,276 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,276 IT Pros & Developers. It's quick & easy.

About Refiling a Combo Box from a query results

P: 36
Hi, Again,

This one is a tricky One,,

I have a Form includes ...

Start Date - Text Box
Start Time - Text Box
End Date - Text Box
End Time - Text Box
Free rooms - Combo box

I also have query which give me results of free rooms that feeds the Free room Combo box in the form ( The Query gets the user inputs FromText box's in the form Like....Start Date ,Start time etc....)

The Question is it works the first time ,... But when the second time i try to change the Input text boxes and click the combo box for the results, the results remain unchanged from the First try.

I think the combo box need something like "UPDATE"

Some help Please
Jul 7 '07 #1
Share this Question
Share on Google+
2 Replies


P: 36
Please sombody Help...
Jul 7 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, Again,

This one is a tricky One,,

I have a Form includes ...

Start Date - Text Box
Start Time - Text Box
End Date - Text Box
End Time - Text Box
Free rooms - Combo box

I also have query which give me results of free rooms that feeds the Free room Combo box in the form ( The Query gets the user inputs FromText box's in the form Like....Start Date ,Start time etc....)

The Question is it works the first time ,... But when the second time i try to change the Input text boxes and click the combo box for the results, the results remain unchanged from the First try.

I think the combo box need something like "UPDATE"

Some help Please
You will need to requery the combo box.

Me![Free rooms].Requery
Jul 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.