Search results for query: *

I have mostly been sucessful in setting up my forms to add new and update existing rows. I took your advice Remou, and defined the table name in the RowSource property of the Combo Box. I still cannot add a row with an empty field where a foreign key should be (I am using a view comprising...

Thanks Remou, I'll give it a try.

I am joining Source Group because the query is used to add entries to Reports and one of the components is Source Group which needs to be either Null or a valid entry in the Source Group table. Richard

Here's a little more info on my query where I could not add a new row. I removed all JOINs from the query and then I could add rows to it. The query is as shown below: SELECT Reports.[Report Code], Reports.[Report Name], Reports.Description, Reports.SAE, Reports.[Used by Max], Reports.[Used...

Thanks for your help so far Remou. I cannot add a record to the either the form or the subform query. The subform query is as follows: SELECT [Report Recipients].[Report Code], [Communication Medium].[Communication Medium], [Report Recipients].Encrypted, [Report Recipients].Recipient...

I removed the subforms from my form so that only the master table and 1 joined table were defined. The query is as follows: SELECT Reports.[Report Code], Reports.[Report Name], Reports.Description, Reports.SAE, [Source Group].[Source Group], Reports.[Used by Max], Reports.[Used by Max - More...

I am using the Access 2003 forms creation wizard to create a Data Entry (DE) form which has 2 subforms that show related data in a grid manner. In both the main DE form and the grid subforms, I have several elements that are combo boxes. The composite form displays existing data correctly and...