I have a main and a sub form that I am working with. I have a date field on the main form that I want to be displayed on the subform without the user having to enter it for each subform line. I have coded the "Oncurrent" event for the subform with:
If Me.Newrecord then...
I am having trouble with code that has to be a simple error but I can't determine what it is. I have a form that is linked to a query with one field. I want to evaluate that field and if it is null, perform an action and if it is not null, perform another action. The query and linked field on...
This should be about as simple as it gets, yet I can't determine how to do it.
I have a table with form that I want to enter data. The fields in the table are: Invoice, InvoiceDate, & Amount. The Invoice and InvoiceDate will be the same for 50 or so entries. On a form, how can I just enter...
I have an expression that I am trying to reference as criteria in the same query. Is this even possible? I think I know how to do that with a form and unbound textbox but if there is an easier way inside the query, I would rather do that. The SQL is:
SELECT [Enter Qtr] AS Qtr, [Enter Year] AS...