How can I make a sub form go a record based on the selection made in a list
box in the main form?
thanks

Access03/WinXP
On a subform, I am using two combo boxes for data selection.  The first
combo box allows the user to select a Primary category; the AfterUpdate
property sets the RowSource for the second combo box where the user will

Good morning,
What is the best way to use the Docmd.MoveSize on the OnOpen Event of a form
to place it on the bottom right hand corner of the maximized Access Window.  
I have tried putting distict values for the [right] and [down], but depending

I have been bilding a form for orders (frmOrders) including a subform for
order detais (frmRows). In the frmRows is a control for UnitPrice. I should
be able to enter data into it in 3 ways:
1. Directly from table Products.

I have an open form event that triggers a restricted form in vba.
strPasswd = InputBox("Enter Password", "Restricted Form")
The form is only code, not an actual form.  How do I astrisks out the
password that is entered?

I've seen dozens of posts in this NG, but none of them has a definitive
answer, at least one that will solve my difficulties.
I have an Access97 development db. I am absolutely certain that I am the only
"user' of this db. I wrote an afterupdate event procedure for a checkbox that

Hi - when a users logs in the following code runs in my system:
DoCmd.SetWarnings False
strsql = "INSERT INTO tblusersloggedin([userID],[loggedindatetime],[user])"
& _

I have two tables like Orders and Order_Detail with primary key orderId on
the first and primary key pair (orderId, itemId) on the second table.
Parallely I have a main form for Orders and a subform for Order_Details,
where both forms are connected with orderId key. Although I ...

I calculated the where clause of mij select statment in a variable,
how can I get the content of the variable in my select statment.
vb
if my variable condition contains "Model like txtModel and status like

FormA can be opened from, and supplies data to, multiple List forms which
contain lists of data entered and edited using FormA. After editing,
entering, etc. using FormA, I would like to refresh any List forms that are
loaded. I am able to write code for FormA's Close button to ...

I need to create a batch file with ~6000 lines in it for ArcGIS. Python is
beyond me, so I'm trying to do this with VBA in an Access module using hints
I've found through this discussion group (VBA is what I know how to use).
Each line should be:

I have a combo box on a form that has three status options -
Open, Closed - NG and Closed - OK.  All records in the
form are Open but the user can close them only if certain
conditions are met.  For example, the record status

I have a quick little pop-up that comes up to give a little more
detail when clicking on the name of a contact. However, I've been
trying to figure out how to close that pop up form when the user
clicks elsewhere on the main form.

Has anyone successfully set the backcolor of a combo box based on values?
Thank you,
Claudette

I know this type is question is constantly asked & searched for, but I have
had no luck with any of the other posts.
- I have the following field: bidNumbr (text type)
- which needs to be formatted like this: 071202-1