[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

[Advertisements]

The recordset for a form can be based on a table or query
An unbound value entered on a form can be used in a query.

eg. unbound value
Forms!FrmXyz.ValueAbc

eg. query
SELECT *
FROM qryMyData
WHERE ((qryMyData.MyValue) = [Forms]![FrmXyz].[ValueAbc] );

You then need an event to trigger the change.
The On Change event for unbound object ValueAbc could have code similar to the following;

Private Sub ValueAbc_Change()
Me.Requery
End Sub


HTH

[dsm]

The recordset for a form can be based on a table or query
An unbound value entered on a form can be used in a query.

eg. unbound value
Forms!FrmXyz.ValueAbc

eg. query
SELECT *
FROM qryMyData
WHERE ((qryMyData.MyValue) = [Forms]![FrmXyz].[ValueAbc] );

You then need an event to trigger the change.
The On Change event for unbound object ValueAbc could have code similar to the following;

Private Sub ValueAbc_Change()
Me.Requery
End Sub


HTH