Forum Discussion
Editable forms after entering data
for example: select * from Orders where OrderTakerID = [the-logged-in-user]
and SomeField is null or SomeOtherField is null or SomeThirdField is null
You can find lots of good resources on various aspects of Access relational database application design on the internet. However, YOUR application will be unique to YOUR requirements. Therefore, a "step-by-step" guide would necessarily entail working through hours of requirements gathering with you to determine what it is you need. Followed by many hour hours of discussion on design and functionality of the interface, as well as the logic required to make it all function appropriately.
For developers who earn a living doing those things for clients, it would be very difficult indeed to provide such a step-by-step guide in an online forum.
But the good news is, as I noted, there are lots and lots of resources on the internet for things like table and interface design which you could study and emulate.If you get to a place where you are stuck on one task or feature, a question here or on one of the other forums could help you resolve that specific problem, though.
- Unfortunately, not a lot of people are going to have time to make a step-by-step.
The short-version is to create a form, and in the properties sheet, set the record source to either an updateable query, or a table.
From there, you click on Form Design/Add Existing Fields and place those fields where you want them. Now the form is linked to the underlying data, and changes are saved "Live". Other users will also see the changes.
To return to a SPECIFIC record, I typically have a separate search form to find results, and then click to open that record in the second form.
