MS Access for Cost Estimation Tool?

[ssanfu]

Did you mean the code on below image would allow me to add a new entry as well?

It depends on the properties of the form and the design of the dB.


Probably yes, but I don't know how your form is designed. You might have a non-editable query as the record source of your form.

[sud2017]

My form is based on a query which contains fields from two tables. These two tables have 1-to-many relationship. In this case, is it possible to have an updatable form? Thanks for your time. It's very highly appreciated.

[sud2017]

Hi Guys, I am able to review the existing records as well as enter a new record now on my form. I based my form on a single TABLE rather than a QUERY and it works fine now. Thanks very much for your time and help.

[ssanfu]

You could also use a main form/sub form arraignment for the two tables to be able to see/edit records.
The main form would be bound to the one side table and the sub form would be bound to the many side table.
Put the sub form in the form footer, set the linking fields... ta da!
You can set both forms to continuous forms (access will complain, but it will work).


Good luck with your project.....

[sud2017]

Thanks very much for your help Steve.

You could also use a main form/sub form arraignment for the two tables to be able to see/edit records.
The main form would be bound to the one side table and the sub form would be bound to the many side table.
Put the sub form in the form footer, set the linking fields... ta da!
You can set both forms to continuous forms (access will complain, but it will work).


Good luck with your project.....