Search results

I have a form which, when it is opened, retrieves records for a date passed through from the calling form. The user can add new records to the table, and I would like the date to default to the date used in the query that retrieved the records. How can I access this date?

I have a notes table in my database. I have used a calendar control so that if you click on a date it gives you any notes made for that date and lets you enter new ones. What I would like to do, when the form with my calendar control is loaded, if there are any notes for a certain date, change...

I am having troube with this. I have a parameter query which is referencing 3 combo boxes on my form. I am referencing the combo boxes with the syntax =[Forms]![MyFormName]![MyCombo] but the values don't seem to be going into the query. Any ideas?

I have a continuous form. A column on the form contains an identifier for a client. When the form is opened, I would like that column to display and client name associated with that ID. How do I acheive that?

I am trying to write some code so that, when a form is opened, the background colour of the field will be set depending on the value in the field - it is a grid displaying statuses, so I want to indicate the status with color. Can anyone help?