My form has a subform and I have a a text box on the main form which is
showing the total value from the footer of the subform.
When the form is opened initially the Tesxt box by default always displays
"#Error" in the text box.

I have a form called Annonce_final_modif, and I want it to open up to a
Phone Number that is entered by the user.  I have an another form called
Annonce_final in which the user
would type in the Phone Number and it will open up Annonce_final_modif to

What I am trying to accomplish is this:
When a user creates a new invoice on frminvoice, then enters the order
details in the frminvoicedetails, but then wants to delete the invoice. I
added a delete command button but it only deletes the record associated with

I want to load a combobox using recordsource.
Then add a single selection by hardcoding that will be the first selection
in the entire list.
there are different ways to attack this problem I think and could use some

How do you delete an item from a listbox?

I am working on a data access project access 2000.
I have a combo box I want to populate using a stored procedure that accepts
parameters.
combo boxes have row sources but they don't have an input parameter property.

Pretty straight forward, I think.  Everything works fine except case 1
and 3...runs 1 and 1 code.  I can't, for the life of me, figure out
why.  I've made sure it's enabled.  I've tried "coid =" &
forms!frmsearch!txtcocoid...didn't work either.  Any ideas??

I have a main form (say MF_1) with a subform (say SBF_2);
MF_1 and SBF_1 are linked together.
In SBF_1 there is a comboBox field: whenever its value is changed,
the afterUpdate event fires ( both field and subform events).

Is there such a thing as text box option group??  ie:  You type in one
box and the others have to stay empty...one or the other type thing.  I
don't think there's such a thing, so I wrote the following if statement
but I get the msgbox when there's only field with data.  I put a ...

I have been trying for weeks to come up with a way to prevent duplicate
entries through the form.  Several other trys on the newsgroups have proven
unsuccessful.  I have a tbl of "Account" with a field of [Cert_ID].  I have
a form named "Accounts" with a texbox named "Cert_Id" ...

Access 97
This code works correctly under most conditions.  It does not work when in a
subform, a field is modified by one number, the Tab or Enter keys are not
used, and the subform is exited using Ctl-Tab.

How can I add to the current code (below) a test to make sure that if
Location 1 field is not 0 or is not null and Location 1 RorM field is null
that a msgbox appears stating that "Location 1 RorM must be completed."? I've
tried the following, but it doesn't work.  Any ideas how ...

I'm using just one form to preview certain records when queued.  When a
recordset changes, how do I get the form heading(label) to change to
reflect the current new set of records??  
If I can change the heading each time the recordset changes, then I can

I have cbo_I and cbo_2 on the same form.  cbo_1 is fed off of a table.  
cbo_2 is fed off of a query that has cbo_1 set as the filter criteria.  So
the options in cbo_2 will change depending on the value selected in cbo_1.  
My problem is that if the cbo_1 value already exists, it ...

I have the following code to send records based on the case to the form
that I have created.  I keep getting the error "variable not found"
highlighting "RcdFilter"
Any suggestions???