I've set up a main form "Companies" with the city field using a DLookUp
expression, and it works fine.  Here it is...
=DLookUp("[City]","Zip Codes","[ZipCode]='" &
Forms!Companies!SitessubformControl!PhysicalZip & "'")

I have a subform within a main form that is setup where each record of the
subform appears as row in the form view (I think this is called a continuous
form).  Well, depending on what appears in the respective textbox of the
"row" I'd like to have another control be hidden.  I ...

I want to have the user be able to add new data to a list without having to
close the form.  I have figured out how to do a macro/event to have a form
pop up so the new information can be entered, but once it's entered, and the
pop up form is closed, it doesn't update the main ...

I have created a subform designed to function as a  dynamic checklist where
the record source contains hundreds of records and the default view is a
continuous form allowing users to display/scroll six records at a time.  I
want to identify the topmost record currently displayed ...

I have a combo box that when after update, I'd like to auto populate the
text box named "ReportArea".
The following is my code but it's not working:
Private Sub Rptdby_Click()

I have a combo box for client id's which I restrict based on who the broker
is using a query.  Only problem is when the form opens it gives the first
client even if it doesn't belong to that broker.
I want the first client for that particular broker to show when the form

I need to be able to read a table, separate names (up to 3 names per record)
from selected records and build a temporary name & address table.  This first
piece of code is executed if the table does not exist....
Function fncCreateName20Table()

Hi all I am using Access 2003.
Since filter by form does not work for subforms, I am trying to create a
filter on the fly.
I have a subform (fsubExplorationLocation) that has the recordsource of

I linked an SQL Database table from a remote server over the internet, via
ODBC.
I can't make changes from Access.  I get a write conflict message with the
only options being to Copy to Clipboard or Drop Changes.  The save option is

I would like to design a form with an associated subform. The nature of my
data is such that for each value on the main form (a 35mm film) there will be
a maximum of about 38 records in the subform (the individual frames on the
film).

Is there any control that would allow me to have a menu bar inside a form
instead of a tool bar ?
I'd like to have one window which come with a docked menu bar inside it, to
clearly show that it will only work there.

Hello everyone! Using A02 on XP. Not a programmer but learning bit by bit.  
I'm using the code below to allow users to fill in a few fields with the
agent data if it applies, otherwise they key in the data. However, I need the
agent info that applies to the contract record that ...

I’m writing a routine which opens a new Word document and sticks content
from the current record into it. I want to put an OLE Bitmap from the current
record into the Word document. I am having trouble doing this. I have thought
of three possible ways to do this. Please advise me ...

This is a silly question, but is there a reserved word to refer to the
current control other than using .Activecontrol. VB uses Me to refer to the
current control, but Me refers to the form in Access. Any help would be
greatly appreciated.

All,
I have a form that displays integer totals from a non-updateable query in
text fields on a form.  The text boxes are meant to change width based on
the integer within the field, like a bar chart (well, it IS a bar chart).