Recent content by tom24

Sorry if I wasn't clear. The two forms are mutually exclusive, so will not be open at the same time. The query will run from each form separately, so I just need to know how I can reference the form that is being used at the time, within a generic query. Hope this clarifies.

Hi, Hope someone can help me. I have written an Append Query which uses data from a form. My form name is "BOX", so a parameter in the query would show as Forms!BOX!Text999 for example. I now need to perform exactly the same query using a form called "CURTAIN", so this would now read...

Have developed a database using Access 2003 - using 2002-2003 format and everything working fine. One of my users has upgraded to Access 2007 and strange things are starting to happen. For example, a simple form control which displays a total value from the product of two other controls (e.g...

Hi, Since posting my query, I seem to have resolved the problem, using the query builder to insert the output of the previous combo box into the RowSource property of the next one e.g. for Chassis Model combo box, the query criteria reads: Chassis Make = [Form]![Chassis Make] Tonne =...

Hi, New member here, so hope I'm posting this in the correct place. My problem is this: I have a table "ChassisDetails" which has 7 columns as follows: Chassis Make (e.g. DAF; ERF; MAN; Mercedes Etc..) Tonne (e.g. 7.5; 14; 18...) Chassis Model (e.g. LF45; Midlum...) Axle Config (e.g. 4x2...