The following is my code in a standard module to save data entry records.  It
saves to the table but does not clear the form to add an additional new
record:  The query saves the subform records.
Public Function AddRcd_Click()

I have two list boxes which I am trying to use as part an email function for
an app I am creating. One list box is populated with names of current
customers and has the following row source
SELECT IIf(IsNull([tblCustomers]![LastName]),"x",[tblCustomers]![LastName] &

Is it possible to make a field on a subform not visible. I tried the
obvious. In design mode of the subform, I set the fields Visible property to
No. When I open up the sub form the field still appears on the subform.
Aarrgh!

I had this question posted already but never finalized a solution:
I am trying to look up a "CWA Number" from tblLabourTransaction using a
unique Reference Number as criteria. "txtAssRefNumber" is an unbound object
where the user enters the reference number to be searched.  

Hello.. I have a form that is bound to a table which includes a field called
"status".  When the form opens, I would like to display only those records
with an "active" status.  Will someone be kind enough to help me with the
coding?

I am trying to set up some custom navigation buttons so a user won't be able
to click 'next record' button and be able to go past the end of file.  For
some reason I can use the built in navigation to go to the first record then
receive an error when trying to navigate back past ...

Good Day all,
 I have an invoice form, with an orders entry subform, within my frminvoice
i have a cboinvoicetype with either "sold" or "consignment", and when this is
selected, I would like to have the value "Sold" "Consignment" saved to my

It seems that the list box will only find on the first character.  Is that
correct or is there a way to make a list box work on an incremental search
the way a combo box does?
Thank you for your help.

I use the following code to open an ADO recordset of a totals query. I then
try to take the total for field TotA and put it into a variable, intTot1.  I
receive an error message telling me the field (SumOfTotA)is not found in the
collection. Am I referencing it incorrectly? or ...

I would like to create a command button that would open a new record and keep
the meeting number from the current record and then give the next sequential
number to the meeting item.
Any help would be greatly appreciated.

Hi.  I have code that is working, although a bit too aggressively!  My
message box pops up before the poor user even has a chance to make entries in
the form.
I need to make sure that one of my keys gets populated before the user moves

I was wondering what is the way i can have blank text fields in a form, and
have them filled out and act as criteria to opne another form.  this will be
much easier for users to use instead of filters.  I know it can be done, i
see it all the time, but iI can't remember how to do it ...

I am using Acc97. I have this if statement of 2 separate forms
If Format(txtDate, "dddd") = "Friday" Then
 'displays the number of work hours for friday
else

I am using the follwing code extracted from an MS access book to pass a name
not in a combo list to an input form.  Ie the the not in list procedure
saves the string OpenArgs opens and  passes the string to the input form.
It basically works (having commented out one line) however ...

How do I turn off Smart Tags so they do not appear at all on any application?
It would be so super if MS would use WordPerfect's Reveal Codes! It would be
an asset to all MS products; it was for WordPerfect.