UpDate Form from query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. Can someone help me please.
I'm new in Access
I copied the Quarterly Orders By Products query from the Adamastor example.
Now, I want to see this data by Month. So, what i did was to substitute the
expression "Qtr " & DatePart("q";[OrderDate];1;0) and wrote "Mth" & DatePart
("m";[OrderDate];1;0). The query works OK.
Then I create a Form based on this query, and it worked OK too.
The problem is: When I update the data with a new month, for example with
dates in October - the query updates well, but in the form thus not appears
the new month. Is there any way of update also the form?
Thanks for your help
 
well i think i solved it:
I put new fields in the form corresponding to the months that have'nt yet
been filled.
But now i have another problem: In that new fields appears (#Name?) and in
the Total Fields appears (#Error) unless all the Months are fullfilled.
Is there a way to solve this
Thanks again

"silvex" escreveu:
 
Back
Top