Update Query

[binksmatthew]

i am making a project that caloculates the costs of gym memberships. i have an update query that can change the price of facilities. however, i would like a form that links to this and i can use to enter the varation in cost. anybody got any ideas on how i can do this.

 

[Ziggy1]

I put together an example, all you do is create your form and then put the control reference into the query as I have it.

the simplest way to add the control reference is to use the expression builder (right click on field in query grid). Be sure to name you contols so you can find them easier.

 

[binksmatthew]

thanks for the example. i am in the process of setting it up.