How to create an Updatable Form

[sud2017]

Hi Guys,

I have created a simple form that is based on a QUERY which contains fields from 2 tables. These 2 tables have 1-to-many relationship.

Intended purpose of this form is to perform cost estimation for various opportunities in my company. I want this form to show existing records (item #, description, qty, unit price), do some basic calculations for extended price and sale price etc.

The problem I have with this form is that although it shows the existing records and performs the calculations BUT IT DOES NOT ALLOW ME TO ADD A NEW RECORD for these fields - item #, description, qty, unit price etc.

I am stuck here for 2 days now, so any possible help would be greatly appreciated. If my question is unclear then I can send a screenshot. But please advise me.

 

[plog]

Any form you want to directly interact with data (add/edit/delete) should be based on 1 table.

If you want to also include additional data from other tables you should use a domain lookup function (DLookup, DCount, DMax, etc) into that other table.

 

[MarkK]

In Access you typically use a single form to show data from a single table. To work with a one-to-many relationship in your tables you use two forms, a main form and a subform. The subform is hosted in a control, which mediates the links between the tables using the LinkMasterFields and LinkChildFields properties of the subform control.

hth
Mark

 

[sud2017]

Plog and Mark,

Understood. It was a quick fix. I based my form on a single table now rather than a QUERY and I can retrieve existing records and enter new records as well. Thanks very much for your help.