I realise this may be a bit of a long shot but if anyone can help me,
I'd be most grateful.
My main form has a dropdown for products A, B, C etc.
In the subform I should like to predefine the row headings Small,

I want the check box to update a rate field. This rate is actually from
another subform on the main form. When I use this code it didn't populate the
rate as expected. Any ideas?
Here is my code:

I'm trying to create an Access application for my personal use that will
index the photographs I take with my Canon Digital Rebel XT camera. I
usually take photographs using the camera's maximum resolution, resulting in
large JPG files (3 - 6 MB)

I was wondering if there was a way to make the tab pages active based
on what a user enters in other fields.  the first tab page has a
control asking if it is a youth or adult.  if the user selects adult i
want a tab page to be accessible (so they can enter more info) if they

The main form “frm_Days_At_Hospital” has two sub forms. All forms should show
data of the same date range (i.e. Admission Date from 03/01/06 till 03/19/06)
having the user to state the date range for the main form only and not for
the two sub forms individually also (In total ...

I've got an issue which I hope someone can help with.
I have an application with a lot of data, so it's shown on  a nested form :
Form has data (user) and subform1
subform 1 has data (customer) and subform 2

I have a combo box which takes its data from a query of a table to
distinguish valid from invalid options.
Once you drop down the choices you select from the remaining legitimate,
chosing this option then drops info from the table into other places on the

I’d like to add in a database a simple help tool.
I have read how to do this using the Microsoft help Workshop, but I try to
work out with something simpler.
Let’s say if a textbox or combobox is focused and the user press F1 a frame

I have a form that contains many tab controls (4 of them). On each tab
control, I put a form on it. My question is how can I relate a [StudentId]
field on a form on a tab control to other forms on other tab controls.
Thank you,

Is there a way to set a control box on a form to always move the cursor
to left align.  For instance if i have an input mask of a phone number
and click on the control box the cursor ends up where i clicked.  i
want it to move to the left so i can type the number.

I have a form with a subform.  the subform allows the user to select an
allergy from a combo box.  this would constitute one record.  they can
then pick another allergy and it would be another record.  after
selecting an allergy in the combo box there is a submit button that

I have a Main form, named as Payment Details. The Cheque no is recorded here.
I have a Sub Form, which lists out all the pending Invoices. I have a check
box  and a Text Box too against each Invoice in the Sub form. I want the
cheque no to be updated in the sub form, when I tick ...

I'm trying to create a database of quotations from various ancient authors,
categorised by language, author, work, reference, quotation etc.
I have a table containing authors, a related table containing a list of
works (many works belonging to one author), a table containing ...

When navigating forms how can I prevent users from seeing/using the export
function, under the file menu? Bearing in mind that, when I'm navigating
around the back tables that I can have full access to this and all other
functions.

I would like to have the user click the button on the form, rather than
sending them to a toolbar.