How Allow user to directly modify the information of a Query through a form

[mfaqueiroz]

Hey!

Everytime that I add information to my main table I have a dictionary table that translate each record to a unique Class. However sometimes i have inputs that aren't in the Dictionary table and the user have to classify this new inputs.
As the follow picture:




I already have a query that gives to me only the new inputs. I'm trying to create a form with a list of this values and i want that the user be able to directly modify the class, but it didn't allow me to do that in a form....
Do you have any ideia how can i do that?


Thanks!

 

[Ranman256]

Queries can be edited. But not all. If your query has joins then it may not be.
If not, use a temp table to get the data you need/add.
Then use a 'save' button to run query to post the data to the correct tables.

 

[jdraw]

Your uniqueness is based on Machine + Status + Area

You need a value for every applicable combination of these 3 fields (as I understand the picture).

It would be helpful to readers if you could describe/explain what these fields mean in "business terms".


Data is stored in tables. You can edit the controls on a form which can effect changes in the underlying table.
Good luck.

 

[The_Doc_Man]

Just as a wild guess, you might consider looking up the "Not In List" event, even though you might not actually be running into that event. It could give you some discussion on how others have handled the "adding missing data" problem.

There are many ways to skin this cat. The first part will be detection that you in fact have the situation where cat-skinning is necessary.