Requery

[Erictsang]

Dear



I have error again for me Requery

I made a combox in entering the "name" , then a button to do Run Query

It will trigger the Room Query

Am i making the synatx wrong ?!


Private Sub cb_htl_AfterUpdate(Cancel As Integer)


Me.cb_htl.Requery


End Sub

[andy49]

Slightly unclear.

You are using a combobox to select a name?

Then press a button to run query? Which query?

Or are you adding a name to the combobox?

[Erictsang]

Andy
Thanks for your feedback

a) i have a "Select Form" which require user to input a value from a combox
b) after the input, click the button of Requery
c) it triggers the Query

I do the procedure the 1st time, it works but 2nd time, the query is not refresh. ( I am opened the form and query together)
But when i close either one, it works again

I tried to go to the input box and made a code, afterupdate - "me.requery". i forgotten once, one of the guru
show me, the synatx should be me.[fieldname].requery

But i try this time not working


In fact , the query result is for a report. I made a report based on the result of this query.
Can i make a button to print this report?

Eric

[June7]

What is purpose of the combobox - just to enter filter criteria, not to save value into a record? Why are you opening a query object?

Code behind button to open report like:

DoCmd.OpenReport "report name", , , "ID=" & Me.cbxID

[Erictsang]

Andy

As want the choice to be dynamic, as user keep inputing into the system

Combox with the sources from the table is a good choice

the query is i selected the fields that to be show /display /result to show to our client

Then a report is made based on this query

I thought this is the logic

form -> query -> Report

But when i try the 2nd time, the query is not able to refresh

i try to build a code in the combox, afterupdate me.requery but not working

I just do not know

Eric

[aytee111]

The combobox only gets updated after you enter or tab out of it. Requery is not the correct solution. And you do not open/run the query unless you want to see the data, but the report is showing it to you so it is unnecessary. June's solution of opening the report directly should solve this.

[Erictsang]

Aytee

Thanks and i tried to do it as per your suggestion

However, it works only if i close the report after the update.
If i open the form and the report at the same time, it will not refresh, i have to do refresh manually.

Is that a way, i can have the refresh automatically everytime when i have new input ?

Thanks

[June7]

Why is the report even open when user selects value in combobox? Is database set for Tabbed Documents? I always use Overlapping Windows.

Are you using a dynamic parameterized query (I never use them) as the report RecordSource? Requerying the combobox will not refresh the query or the report. Command to requery report would be like: Reports!reportname.Requery. The report has to be in ReportView, won't work in PrintPreview.

What do you mean by 'show to our client' - are they standing there looking over your shoulder as each record is entered and need to see the change in the report?

[Erictsang]

June

The combox is set on a form - i call it request Report form the input is based on "service type"there is around 5-6 of the kinds

So, once the user select the service, the report will generate based on this input. I made a query for that and it then lead to the Report

As you said, i skip the me.requery , and open the form directly. it works

But when the user go back to the form and reenter a new services while the report is still open, it does not refresh. i think same as the Query.

I was told that we can do requery and after the user enter the new input, tab, then it will trigger the requery.


i try me.requery in the afterupdate in the combox but invain.

I think i must have done something wrong

Appreciate your comment

Sncerely
Eric

[June7]

Didn't provide any new info. Didn't answer my questions in post 8. You should read that post again.

If report RecordSource is NOT a dynamic parameterized query referencing the combobox, following code can work for ReportView or PrintPreview.

Reports!reportname.Filter = "ID=" & Me.cbxID
Reports!reportname.FilterOn = True

Why do you even need to show the report to a user entering data?

[John_G]

But when the user go back to the form and reenter a new services while the report is still open, it does not refresh.

What doesn't refresh - the form or the report? If you are talking about the report, then it is because open reports do not refresh the way forms do when the data changes. If you want the report to reflect changes to the source data, you have to close it and rerun it.

[June7]

Eric, are you entering a new record or just entering a value in UNBOUND combobox as filter criteria?

Report in PrintPreview cannot be requeried/refreshed to display data entered/edited, must be ReportView, otherwise close and reopen report.

If the combobox is just to select filter criteria, the code to set Filter and FilterOn properties will work for ReportView or PrintPreview.