I need help on this urgently. I have synchonized combo boxes on a form,
which show the value, and when submitted, the ID of the value gets
captured. How do I create a query which will display the values
instead?

What I am trying to do is use the results of a query based on the value of
one text box on my form to populate the values of 3 other text boxes on the
same form with the values from the query. For the sake of the discussion we
will say that my four txt boxes are UID, employee ID, ...

Below this question is a description on how to replicate the probelm, but
i'll overview it here:
As access saves a record, that record is then needed to be accessed
immeaditly via ADO, however it takes ADO 2/3 seconds to be able to access the

Afternoon folks!
I've got 2 popup forms that trigger from NotInList events. This morning, I
got the first working ok- the Add and Cancel butons add or delete the new
record properly, the form requeries the original box putting the value in

How's everyone doing? Smiles all around?
I have a problem with a text box that is in the details section of my form
layout. Several of my text boxes are set for Can Grow and Can Shrink but this
causes another text box to be seperated from its label since the label is

i want to filter a form while typing in a text box.
for example typing John, i want to show all records starting with j when
type j, and
those starting with jo when have type jo e.t.c

I have the following code behind a Find button
   Dim stDocName As String
   Dim stLinkCriteria As String
   stDocName = "Achievement"

I have a main form with a combobox called cmbSearchField
It is used to see if the value in the combo box exists in any of the records
in
qryResults

I have written code that imports data from another program. The plan is to
import that data into some temporary table, have some method (boss prefers
radio button) to select information that is not needed and delete it and then
send what's left to a form (subform). Any ideas on ...

i want to have one button which can be clicked to prevent deletion or
edition of a record.and , at the same time, have the ability to delete or
edit the same record by repressing the same button or another button. is this
possible.

I want to be able to update a form that is open based on entry that I
am entering into another subform. When I change the data on the main
form, IE..Employee I would like for the 2nd form (not the sub form) to
change also. Is that possible?

Hi, I'm pairing a text box and list box and using incremental search to fill
the list box based upon whats being typed in the text box, unfortunatly there
are now a large number of records and users accessing the data.  As a
consequene this routine has now become unbearably slow, ...

how do I disable the scroll down button from the mouse while I run through my
records in access form. ideally users should use the next button which is
saved on the form than using the mouse
any help

what is the appropriate way to manage an unlinked subform?
I have a tab on a form that serves as an independent search page for data.  
But this page should in no way be related to whatever record is on another
tab.

Is there an elegant way I can insert data into a table in my mdb file from a
SQL table using a single ADO call? Or do I just need to open two recordsets
one to the SQL table and one to the local project and step through each
record?