Reposting to correct group ...
----------------------------------------------------------------------------------------------
Hey folks!
I got a head-scratcher here (at least for me ... perhaps not for you).

I received an error message that essentially asks you if you want to exit
without saving, YES or Cancel are your options. I customized this message in
vb, but now when my error pops up your only option is to say yes. How can I
keep the Cancel button that was on the original error ...

I'm diagnosing a problem with a database. It is using this code to save the
current record on a form:
     DoCmd.Echo False
     x = GotoRecord("Previous")

Is there a way to code a continuous style form so that specific records in
the list will trigger other records to either be visible or not as the rows
build down the form?
I have two examples where I need to selectively highlight textboxes on a

Damian was helping me with this, and I thought that we had it. However it now
appears I was wrong. So I'm re-posting my problem.
I have a form that is being used to select criteria for a search. One of the
criteria I have is a weekly allowance criteria with a low and high text box ...

I am using a continuous form to show a query. It has a form header with the
field names and a form footer with filter buttons and boxes for the user
input/select criteria to modify the list.
I have a command button with this code in it:

I have a form in which I create a new crew record, and a members subform in
which I assign members to the new crew.  The records for the crew members
already exist – I just need to update the crew number field in the
appropriate record.   I also want to display any members ...

Help - This code is suppost to look for the Employee Number chosen in the
Employee Number Combo Box on the Injury Journal Data Entry Form and matches
it to the Employee Number in the Employee Master Staff Table and pulls in the
Supervisor and Department associated to that ...

When I open a .mdb file it opens up a form.  How do I get to the design view
of the form?   Nothing on the menu lets me access the design view of the
form.  I don't know if this file has been compiled?? or not.

I have a Corporate Data Form that shows all the details of our corporate
clients. This is accessed from the built-in switchboard, in either Edit Mode
or in Add mode and has been working fine.
Recently I created and added to this a subform to contain details of the

Hey you all.
Here is the problem. I have drop down menu where I choose a employee role.
According to this role I would like to populate a list box. List box will get
the values from table where every record has role saved. So when I choose

I'm wondering how I can display values from a form query in the ControlTip.
I've got a 'name' field which is very short, but there's also a longer title
which I don't want to accomodate on the form itself, but would like to
display when mousing over the name field.

there are two combs in a form. They are all based on select statements to
fill data.
one selection of a comb should decide the other's select statement's where
clause.

I have an unbound field [NetWt] that multiplies 3 other fields:
[UnitCount]*[SubUnitCount]*[DecWtg]
The problem is that [SubUnitCount] is sometimes NULL therefore, the return
is NULL.

I am having a problem with Invalid Data type when trying to add a new record
with a ReplicatorID in it.  I get a Data Type Converion Error.
       rs!TankID = CStr(Forms![TankInfo]![TankID])
or