Changing data on a form

[oxicottin]

Hello, I have a continious form named frmSuperlog thats control source is a query named qryDailySuperlog. In the forms "Form Header" I have a date picker with a text box named txtSuperlogDate that holds the date and I have a combo box named cboSupervisor that gives me a list of supervisors names. These two boxes are used to filter the query. In the cboSupervisor(s) afterUpdate I have it run the query. My question is every time I choose a new name from my combo box it changes the data in the continious form which is what I wanted but when I change the date I have to reselect a name in the combo box for all the information to change on the form. How can I fix this to where if I change the date it runs the query and if I change the name in the combo box it runs the query?


Thanks!

 

[rainman89]

how about a me.requery in the afterupdate of the datebox?

 

[oxicottin]

tried all the requery formulas and nothing works

 

[rainman89]

can you post a sample up?

 

[oxicottin]

I just exported the form and the query so you get an idea of what im trying to do. Thanks!

 

[rainman89]

without the tables and structure, i cant get the form to do what its supposed to. can you add the tables required?

you can delete all of the data

 

[oxicottin]

Ok here is the database with all intact! I kept dates 12/18/2007 threw 12/20/2007 in the tables so there was data... Thanks!

 

[rainman89]

ok what i did was put

forms!frmsuperlog.requery

in the onclick event of the calendar ok button.

 

[oxicottin]

Awsome! But by looking at the way it works am I doing it right?

 

[rainman89]

Awsome! But by looking at the way it works am I doing it right?

It's hard to tell because I don't know your real world situation, but overall it looks very functionable, and if it does what you need it to do, then I'd say you are doing it right.

 

[oxicottin]

One last question? Since you added the requery to the calendars OK button will it affect the use in all my other forms? thanks for the help!

 

[rainman89]

no because i have it requerying only the superlog form

 

[oxicottin]

I have another question? Is it possible to have the cbo box already have one of the 3 names in it? this way when the form opens it isnt blank? I got the date now I just need the combo to have a name. Thanks!

 

[rainman89]

you can set the default value to something yea

 

[oxicottin]

Thanks for all your help!