I hope someone can help me with this.  I have two forms.  One form has the
Doctors info and patients assoc to this doc.  The second form has the
patients info and lists the docs assoc with pt.  On my doc form I have a
command button to go to pt form and vice versa.  This works ...

I have three linked tables that I want to enter data to using a single form.
These tables are:
tblMember – which stores the details for a member. Its fields are id,
firstname, surname & occupation

I am trying to create my startup page but I am having trouble with the
command buttons.
I want to create a button that will add a new record to my database. When
the users presses the button I want it to take them to my main form to enter

Okay, I know this is very basic, but I can't figure it out!
I have a form with a tab control.  On one of the tabs I have 8-10 unbound
checkboxes that I am using to allow users to select options before running a
series of update queries.

I am at a loss. I I don't know what happened but this morning
when I opened up the form I am working with, it didn't allow for new records
and would not let me update the displayed records. I am supplying data to the
form via a query with this SQL:

have a form that has 48 text boxes.  The user enters data into the unbound
text boxes first then after they review the information I move the
information from the unbound ( me.bound = me. unbound)  to the bound text
boxes to add the record to the table.  The first 3 to 5 records ...

I have a subform called [Short Service Contract Details] whose "Visible"
property is set to "No". I want to change the visible property to "True"
based on the After Update of a combo control. I've used the following code:
Forms![Short Service Contract Details].Visible=True.

I have a large number of queries, forms, and reports on my project.  I was
wondering how long it usually takes to create an .mde file.  Anyone have an
idea? Thanks.

I am trying to have the values of 2 controls on my form when opened = (blank)

I want to refer to another control in my form that will use a formula like
the "if, then" formula.  I know how to do the "if, then" formula, however, I
am going to be using more than one "if" and I do not know how to write the
formula correctly.  What I want to do is say If ...

Can we use Hyperlink address property on Label Form to run the table (e.g:
Table1) in my current database?. If anybody can help me, I am very
appriciated.
KT

Hello, i hope someone could help me with this.
i have a multiselect list and as i select and click on a send button, i send
the items to a new table. this is my code.  the if statement will do the IF
it already exist dont send to history table(ProdHistory), but somehow its not

I am wondering if it is possible to change the WHERE clause of this statement
to select the current record of a form.
Lets say on a search form a user searchs for a record, i would like them to
be able to press a button and have that record put into another table. I have

I have a form with four comboboxes that are set to draw their RowSource from
different fields of the same form (Patient Information). The four boxes are:
MR Number (the unique primary key of the table), Last Name, First Name, and
Date of Birth. I would like to be able to select a ...

I have a calendar on my form that i want to use to imput data into a text box
but i have not been able to get it to work. They are bound to same control
and i even tryed adding a requery to the calendar update code. I am using
access 2003 i tryed downloading a sample from 2000 ...