I know this should be simple but for some reason I am just not getting this.
I have a text box control on a continuous form as follows:
Name: lotCost
Control Source=IIf([qUnit]="each",[qPrice]*[qQty]*(Forms![Main

I have an issue with my Access 2000 database.  I have a form with a subform
in it.  Since I have a subform, I am unable to open a connection
consequently, unable to open a recordset.  There is a fix but I am not going
to implement this.

I went through a lot of the messages and tried all the suggestions and still
could not get the ending results I'm trying to find.  It is so simple; I am
sure I'm bound to be made to feel like an idiot once someone tells me how to
correct it :)

on my form i have a date field that is updated by users. on the form is a
combo box that has the date field as one of its column. after the date field
is updated (changed) by the user, when the combo box is opened, the combo box
still shows the old value of the date field instead ...

Is there a way to partially format the code below so that the wording (e.g.
"On 6/22/08 Silvio wrote:" to be in Red and the rest of the comment to be in
black?
Me.ProjComments = "On " & Now() & ", " & DLookup("UserName",

How do I programmatically count how many control in my form are not null?  
All the controls are unbounded. The form has 13 controls. This total will
progress as the user fills in all the required control. In short, I have a
progress bar (13 means 100%) that will count the ...

I have a rather larger form which I split into tab'ed windows to make it much
easier to navigate and understand.  I linked each page using a unique record
source (ReportID) and origianl set this as my primary key because I can not
allow duplicates.  I later added a primary key as ...

How do I programmatically count how many control in my form are not null?  
All the controls are unbounded. The form has 13 controls. This total will
progress as the user fills in all the required control. In short, I have a
progress bar (13 means 100%) that will count the ...

I have a problem with my form properties with the moveable and the min and
max buttons. In VB it will not allow me to change from false to true and also
I have my I don't have my form set to dialog but it still will not allow the
min or max buttons to show. The control and close ...

dear friends,
privatesub myform_befreupdate(cancel as integer)
'ow to update multiple records to same table ay one event
'im usingcode

I have a form with two subforms that I have used for data entry as well as
reviewing the records.  Overtime, I am noticing that some fo the
functionality is diminishing and I can not figure out why.
For example, one subform has a few comboboxes which have been working fine.  

I have a form with 3 text boxes.  These text boxes have an expression in
their Control Sources such as pulling the network ID of the user
[=fOSUserName()], current time [=Now()] & server name ["Srvr1"].
The user will never see these text boxes but I would need the values added to

I have a query that requires the user to specify two parameters which I
obtain from a form with two combo boxes and a "Run Query" button. I use a
combo box with a query as its data source for the first parameter. I then use
another combo box, on the same form, with another query ...

does someone know the trick to refresh a listbox in a subform after the
event of navigating through the datasets of a parent form. I can now only
achieve this by clicking a requery button WITHIN the subform, I can not
force the requery from the superior form.

I am using Allen Brown's search form in a db and it works great.  I want to
double click on a record in the detail of the form and open my data entry
form to that record.  Can someone tell me how to accomplish this.  I tried
the code below, but it wouldn't work, it keeps asking ...