Active query's during forms

[comanighttrain]

hey guys, im stuck, basically, i need to get the output from a query and display it on a form while the form is being carried out. The paramaters of the query are provided by the form, basically i have 4 involved tables.

Facility
1
m
Booking
m
1
Member
m
1
Category

Booking needs a cost, the cost is calculated from price_per_session in facility, minus a percentage of price_per_session that is calculated using percentage_discount in the category related to Member.

my querys are all right, the only problem is i usually develop my own Gui's for Databases

 

[missinglinq]

From the Database window select "Forms" -> "New". At the top of the Forms box select "Design View" the at the bottom of the box select the name of your query and click OK. You will be presented with a form blank and a list of the available fields. Right Click and holding down the right mouse key drag each field desired over to the form and position it as desired. A box will appear for each field, as well as an attached label for the field. If this doesn't suit your design sense, the labels can be deleted and replace later with labels of your own design. When you're thru click on the "View" icon on your toolbar and you'll see what the form appears like.

Hope this helps!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[comanighttrain]

yeah, i get that

the problem is that i need to calculate a value and have access put the value in the Cost text entry box which in turn enters it to the booking table.

 

[missinglinq]

Assuming that the "Cost" text entry box is bound to the booking table, in Design View go to the Properties for "Cost" and in the Control Source property enter an "=" sign followed by the formula that defines the cost. This should do it.

The Missinglinq

There's ALWAYS more than one way to skin a cat!