Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Access forms problem


  • Please log in to reply

#1
comanighttrain

comanighttrain

    Member

  • Member
  • PipPipPip
  • 553 posts
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
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
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
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP