I have the following code that tests if a number is already used, but I would
like to modify it so that a user can click a command button and have the
combo populate with the next free number.
--------------------------------------------------

Good day!
Please bear with me with my current situation.
I need some help regarding my Inventory Monitoring Database i would
like to implement in our office. First, Here is what i am trying to

I have a combo box on my form. Its default value is not set. The combo is to
select text values to be inserted into a text field "AccountID" of table
"Payments".
When the combo is updated the following code runs:

Apparently I did not make myself clear in my first posting.
The code DOES WORK if the two top procedures are called by a double click event on the combo box
The code DOES NOT WORK if the two top procedures are called by a single click event on the combo box.
The help for error 2115 ...

I have 2 combo box (cbogroupno and cbocompany) I want this 2 combo box
filter each other
i mean:
When select cbogroupno:

Thank you
I have combo box
Control Source=
Row source type= table \query

Guys,
Please help me on how to do the below calculations.
Date (YYDDMM)
          080131    = it goes like this 8+1+3+1 =     13 is the answer

I have a form where a user selects a ref number and then another form
opens with this record details showing. The problem is the record does
not lock until the user begins to type an update in one of the boxes.
In the meantime another user can open the same record and begin to

I have a function that returns an integer - let's call that integer
'x'.
How do I insert new records in a table equal to 'x' and insert
something that's modified by x-1 on each pass through the loop?  I'm

I have a selection on my Switchboard for Edit Record. This runs a
macro which runs a query parameter asking for a Ticket Number. The
number entered should pull up the correct Record to Edit, but it's
pulling up any record. Currently I have one record in my system.

I'm trying to display a custom error message if the person misses entry in
ANY of the Fields. Is there another way I can have the Error message display
BEFORE the record saves and moves onto the next form ?  It seems the code
works up until a point. It displays what items require ...

We have a form in which we wish to validate the data in each field as
the use exits the field.  For example we have a part number field which can’t
be null or blank so we have the following code in the exit event for that
field.

From this newsgroup, I was very happy to be able to enable or disable
controls on my form, depending upon whether there was data already entered in
the control.  It works very well:
Private Sub Form_Current()

I have a field called "Loan Boarder". I need a simple piece of code so that
when the boarder clicks on the command button, it will automatically fill in
their user name, current date and current time. I can get it to fill in the
date and time by using Now() but don't know how to ...

I am really struggling with an input form for new patients.  Input form
should NOT allow duplicate SSN's.
Table called patient data contains SSN (text Field).  There is also a field
called ID that is numeric.  I have the following event procedure coded to the