MS Access help

[OuiKikUrAzz]

Nothing to deal with websites or anything just basic access help

I want to know if/how I can do the following:

I want to setup three columns within a table where if one of the columns in updated that the other two MUST be updated also (per row basis)

sounds kind of dumb but the db is setup to manage some client information.

 

[Brian48]

You didn't mention "updated with what", but yes it can be done. Assuming that the person is entering the data using an input form, you can program the "on-click" event (when the person hits the save button) to populate the other two columns with whatever data you want. Naturally, if the data is fixed and hardcoded, it's much easier to implement than if it was a calculated value.

 

[OuiKikUrAzz]

lost me in the middle...it's being hard coded from access. It is all text value. Someone told me about programming it to all required fields and when one is updated the other two are cleared therefore they must enter something for the other two to continue but the thing is I don't know any Vb script and am kind of vague on how to implement them into the table. help required

 

[OuiKikUrAzz]

bump