Search results

I have a form created from a table and I had to use calculations in some of the fields to automate certain processes. Now, if I pull a report based on the fields in the table - I am getting all except for the fields with the calculations. Is there any way to update the main table - since most...

can u explain please?

I have a report based on a parameter query which prompts for a trans#. It works fine, but is there any way to customize the "Enter parameter query" text at the top of the prompt box?

I have a database that I want to install on a client's pc as a demo only. I want to restrict the number of records he can enter to 3. Is this possible in access? I will appreciate any help. Thx!

Thanks for your responses so far, they have been really helpful. I have decided to change a few things. I created all the forms from the combo box as subforms in the same subform with the combo box. I want to have them all hidden, unless that specific option is chosen - then I want that form...

nope..still not getting it...any further help please?

What is cbo? I guess you know the answer to your first question! I've never written any code, but I'll try to follow your example and play around in it. Thanks!

No there is nothing in that field.

can u explain...sorry to b such a dummy :o

I have a Subform with Insurer being a field with lookup values e.g. fire, motor etc. When I select fire from the lookup, I want the form "fire" to open to allow data entry. Same too for any selection I make in the lookup - the pertaining form must open.

I have a form with a subform which has a lookup table (combo box) as a field. I want to be able, when I select a certain item in the lookup to have it automatically open a form. e.g. A field called insurance class - I select motor, I want the motor details form to open. If I select Fire, I...