Search results

If you are using DoCmd.OpenForm you could use the OpenArgs Parameter to pass values to the form being opened from the calling form You will need to write some VBA in the Form_Open event of the form being opened to use the paremeter value passed. NAD

aleb is correct. The query will run on the client PC and will generate lots of traffic from the remote SQL server and your PC. When dealing with large amounts of data using ODBC linked tables you will nearly always get better performance by writing the query as a pass-thru. Regards NAD

One method would be to deduce the postal address in a query and then use the query as the data source for the report. You could use the iif() function to derrive the column result e.g. iif(WhichAddress='W',WorkAddress,HomeAddress) To assign the column a name Prefix the calculation with a...