Search results

The sub form is it a Continuous or single form. You could have a query as the record set for the sub form and filter the query using the combo box to show the relevant records.

Just to expand on Galaxiom Date () gives you just the date Now () gives you the date and time

Hi Is Died on the same table as the other fields? and with trying to reference the checkbox sounds like either the form isn't open or your not calling it properly forms!formname!checkbox

There is a label wizard in access so I would look to see if that can do what your looking for, if it doesn't then search for something called a mailmerge. Sorry I couldn't be more helpful

Hi, if you go into design view on the query and enter this code into a new column IIf([forms]![nameofform]![nameofbox]="" Or IsNull([forms]![nameofform]![nameofbox]), [nameoftable].[nameoftablefield] Like "*" Or [nameoftable].[nameoftable] Is...

Hello All I recently started a job where I am being trained to use Access and I am enjoying learning to use it and all the challenges it brings.