Report showing blank from form

[nmeuvdast8]

Hello there. I need your help.

I have created a meter reading database. In this DB, I have a meter reading form (frmMeterReading) which has the following data:
ReadingDate
ReadingID
SerialaNumber (foreign key)
Readings

I have a form for data entry (frmMeterReading) to the tblMeterReading. The ReadingDate is named as ReadingDateText and the serialNumber is named as serialCombo (since this is a combobox). In this form, I wanted the user to enter all data, save, and then print (open report that I have created). The data entry and saving part works ok, its the printing that I am having trouble with, it shows blank. Here is thr code I used for the printing. (Open Report)...

DoCmd.OpenReport "rptBilling", acViewPreview, , "ReadingDate like'c & Me.ReadingDateText & "*' And serialNumber like ' & Me.serialCombo & "*'"

I used the same code in another form, frmSearchBilling with the same parameters and it works. I think the problem is that in the frmMeterReading, the control source for the form is tblMeterReading whereas with the frmSearchBilling, the control source is a query I made with a select ststement. The rptBilling control source is a query I made.



How do I implement this with the current structure of my frmMeterReading with control source as tblMeterReading? Also, currently, I have separate save and print buttons, is it possible to use a single Save/Print button to do these 2 actions? I have tried but Iam having trouble with the Goto Next record new.

Thabks in advance!

[Welshgasman]

Dates should be dates, period.
Should be no need for like in either of the criteria? I would expect just the serial number and perhaps a date range, where I would use between for those.

Try a query with that criteria and play with that until you get what you want, then use that as the WHERE criteria for the report.

[ArviLaanemets]

What are you trying to get from 'Me.ReadingDateText & "*' part? Whatever it returns (when ever), it is not a date! So no matching record can exist!

[nmeuvdast8]

What are you trying to get from 'Me.ReadingDateText & "*' part? Whatever it returns (when ever), it is not a date! So no matching record can exist!

What I am trying to get from the Me.ReadingDateText is the date. Its actaully a date field in the form, I just named it ReadingDateText so can I easily reference it in VB code

[ArviLaanemets]

What I am trying to get from the Me.ReadingDateText is the date. Its actaully a date field in the form, I just named it ReadingDateText so can I easily reference it in VB code

Today's date is a number 45740;
LIKE operator is really meant to compare strings, so I'm not sure what happens when you apply it to numeric value? Maybe in case you get all dates LIKE this one, those must be today's date, or any date>= 457400 - i.e. 25. April of year 3152 or later?!