Search results

I have a form with 2 subforms. The 2nd subform creates a new record in the table when I enter information. I want it to populate the exsisting record. I have looked at alot of sites trying to find information on a multi-table form or a form with multi subforms. Please help the creation of a...

I have created this query: SELECT tblCategories.Category, tblThings.ThingsName, tblThings.ThingsCabinet, Nz([ThingsAmtPurchased],0)+Nz([2ndPurchase],0)+Nz([3rdPurchase],0) AS [Total Purchased] FROM tblCategories LEFT JOIN tblThings ON tblCategories.CategoryID = tblThings.CategoryID; Now, I...

I have created a Form with a subform. The main Form is Supplier. The subform is the gifts. They are related. I can not get Supplier to change. The Control source is the table. The name and address is bound to the ID. What I want first is for the Supplier to change and the subform will...

I want to create a Form using 3 tables that are related. My form will not display in "Form" or "Layout View".:mad: I am using the Form Wizard.

Unless I do not understand the IIF Is Null statement meaning but I am trying to combine this: IIf(IsNull([SpouseLName]), ([SpouseTitle]),[Rank] & " " & [FirstName] & " " & [LastName] & " and Guest",[Rank] & " and " & [SpouseTitle] & " " & [FirstName] & " " & [MI] & " " & [LastName]) Please...