Search results

Cheers guys, just what I was looking for! :)

When two dates are selected and the gender button is pressed, it brings back a form based on the query (I.e. the number of records between the two dates given by gender). All I need is the two dates that appear in the unbound text boxes (ealiest and latest dates) to appear somewhere on the form...

Worked a treat! Thanks very much! I like the three eyed duck by the way. Thanks again Rich

I have the first part working but the what do I need to put in the '[ID]' part? Thanks for your reply mr duck.

Please help meeeeee! How do I get error msg to appear? I have a button on a form that runs a query. The query relys on 4 text boxes to be filled with data (the first two being two date fields to show a range of dates and the second two being two integer fields showing a range for age). Once...

I know how to make one field in a table mandatory (required). How do I make one of three required? I've got three fields: Date of conclusion OR Duration OR Untill further notice The user HAS to enter one out of the three. Help on this would be greatly appreciated! Rich

That has worked an absolute treat. Thanks guys! And thanks for the speedy reply's! Rich :cool: (I should really learn how to spell . . . 'Calender --> Calendar")

I have a form connected to a query that uses a pop up box for the user to enter two dates DD/MM/YYYY. I have: "Between [Enter first date] and [Enter last date]" typed in the criteria section of the query. The query brings back records I have defined between these two dates. What I need is a...