I'm still relatively new to Access and I want to make a form that allows the user to edit a grouped field all at once (if this is possible?)?
For example, lets say there are 13 records in a table and in one column a the type is kept, either 1 or 2. For each type there is a price that changes. So I want the user to be able to select either 1 or 2 and edit the price and then on the one edit have all the records of that type change with the same one edit.
I have no idea how to do this! Please advise or reference places to get the information.
Thank you!
For example, lets say there are 13 records in a table and in one column a the type is kept, either 1 or 2. For each type there is a price that changes. So I want the user to be able to select either 1 or 2 and edit the price and then on the one edit have all the records of that type change with the same one edit.
I have no idea how to do this! Please advise or reference places to get the information.
Thank you!