Hi, I'm new to Forms Coding, I would like a text box to display the word
"member" if a value in the forms underlying query is true (bit - checkbox)
I have the following as the text box's control source:
IIf(Nz(ActiveMemberCompany)) = yes, "Member")

i have a form which holds two fields (chk box) recommended and chosen.
the query then filters all records that are recommended for a particular
client.  i have then at the foot of the form created a total of recommended,
no problem.  

I have a form. I have it bind to a table and with custom button i can
move trought the records. Till there it's pretty easy.
The form is use for the tech support, sumone put a call we answer, fill
up a ticket doing updates like calling another person, doing

I have a continuous form that should accomplish two goals: search for records
relating to a project (via an unbound combo box) and save a new record in a
table for the project selected in the combo box.
The form is bound to the table so that the user can select a value in the

I'm a newbie to ACCESS.  I'm using ACCESS 2002:
I have a one database in which I am trying to set up a push the button do
everything system.  That didn't work because I have the import, export, and
check everything stages.

I have a form on which there are a series of records in a matrix – example as
follows
        Amount                 Amount                 Amount
Record 1        50.00                80.00   

In my form which allows user to input data to records, it consists of a
textbox named "FileType". How can I write in the event procedure such that in
the first time, i.e. when the textbox is originally empty, it allows user to
input text in it. But later on, when the user want to ...

I've used the DoCmd.Maximize command in my main form's (frmMainMenu) OnLoad
event so that it will automatically enlarge to whole screen once the form is
loaded. However, the problem is that after using such code, it will also
affect other form so that once I click some buttons in ...

I have 2 queries based on the same table relationships. One of them has an
additional criteria. I would like to be able to display the results of either
query in the same form. I though that this would work..
DoCmd.OpenForm "frmMiscForm" , acNormal, "qryTest1"   (filtername refers ...

I would like to have a user enter a start date and an end date into two
textboxes on a form. The two dates will be used to query a table. I
would then like to print a report that was created from that query.
Here is the query created as a stored procedure:

I have some code attached to a cmdButton so that a user may send an email
from the form with the information from the current record. The code and
button works perfectly! However, if the user clicks the button an the email
appears and the users chooses NOT to send it after all, ...

Want to enter either a particular Manager Number or leave blank (when left
blank, I want to pull all Managers).
I can pass a particular Manager Number to a query and get info on that
manager - this works fine.  How can check for a blank entry, and then have

I'm using a combo box to filter deliverys by group name.  The form is based
on a select query which pulls all deliveries within a specific date range.  I
have the combo box in the form header pointing to the Group Name table
(Account No, Group Name).  In the After Update event ...

I have a continues form based on a date add query, that displays ship dates
from now through now + 60 days.  I'm trying to code one of the text boxes
(soldier's name, for example), on the forms' individual records to display as
red or green based on a check box in the record. I'm ...

I had searched the forum. I can't find a solution exactly what i am looking
for.  Home someone can help me here.
I have a main form and subform.  When I select an ID in the main form it
displays the related records in the subform.  My subform's view is Datasheet