Search results for query: *

I finally got the syntax correct. This is an excellent reference I found from another forum: http://access.mvps.org/access/forms/frm0031.htm Thanks for all the help

Here's my problem; I have a tabbed form (frmMain) that has several unbound subforms and most of those forms have subforms. One tab has frmBudgetSetUp where I want to requery a list box on two other forms after I create a record (I have other code that creates the record). I can't get the...

Well, I had a spelling error in my form in the "billingperiodno" field, so that's where the error was...it works perfectly now. My only issue now is getting it to requery correctly; I started a separate post on it, but I am still struggling. I can't seem to get it right. Thanks for the help...

I get the error when I click the command button. I don't know how to see what the variable value is. The entire strSQL is highlighted. I don't have any other code surronding the form, other than form navigation buttons.

That got rid of the compile error, but I now get a runtime 2465 "application-defined or object-defined error" I guess the only other "surprise" is that I have all my forms on an unbound, tabbed "frmMain" Don't konw if that's relevant, but I thought I would give you the whole picture.

I think I need to refer to the Me.BillingPeriodNo differently. Me.BillingPeriodNo is on the master form 'frmBudgetControl' and the data is in the subform 'frmPayments'. I get a compile error stating "method or data member not found

the controls are bound to the form/subform, I just have them on an unbound 'main' form that is tabbed. Where is the best place to run the macro? In the actual control?

I have an unbound main form with tabs that have my various forms for my application. I am having an issue with the data not refreshing; I think I need to be using the requery action, not the refresh. I guess I have two questions: 1. Is there a way to generically "Requery" form data when I...

I am trying to create a set of records in tblPayments based on the the records in qryBudget. The two tables are related by cost code. I am creating a command button on a form (based on the billing period of the payments) to run this expression. I want to create the records using the...