I have a button on my form that prints information from the current record of
the form I am viewing.  It only works if I close the form and reopen it after
entering the data.  I added a Requery command to the first line of code on
the button but it ended up taking me back to the ...

Bump- Sorry, still need help with this issue. Thanks.
Thanks for you help. Sounds like it might not be the best way to do this but
is it possible? It would make things easier for me.
-------------

I am using the following DLookup() function on a subform and it works....as
in it shows the data I expect it to when I view the subform in "form view" by
itself and not as part of the master form.  When I view the master form the
Dlookup up function returns "#Name?".

I have a form with numerous tabs on it.  On one of the tabs is a
subform that lets the user select a program from a drop down list.
Depending on which program(s) are selected more tabs could be opened up
to enter new information.

I have a table and a form in my database.  On my form, I have used the
command button [Add New Record] and it lets me enter my information.  I would
like for my ListSeg Field in my table to update every time a new record is
added.  

OKay, I have been beating my head up against the wall for the past 4
days trying to get this to work... I have a form with a subform
(default is hidden), the idea is to be able to browse a resource
database OR, should you choose, search the database by criteria you

I used to have a subform where the user  inserted each the data for every
field and I had an equation to get the total weight [EsigenzainKG] as
follows
=[Colli x Pedana]*[N° Pedane]*[Desc]*[netto]/1000

I have a form that prints a report using the following code
Private Sub Command67_Click()
Dim strWhere As String
   If Me.Dirty Then    'Save any edits.

I give.  I have read the evils of Lookup Fields at
http://www.mvps.org/access/lookupfields.htm.  I am curious whether this evil
only pertains to lookup fields at it relates to tables or all lookup fields.  
How else do I have a combo box that draws its data from another table ...

 I am constructing a database for a plant operation. Each department will
have identical inputs with the exception of the machine number. I first
constructed a form with a dropdown list of machines for the first department
and realized I would have to duplicate the form and table ...

I just realized a problem. I have a table that the info on this form dumps
into. When using this autopopulate it works great on the form but's doesn't
dump the fields that auotofilled into my table.
Any ideas?

I'm working as a graduate research assistant for a large state agency
developing a database of historical construction records.  Thus far,
I've developed my database in Microsoft Access because it, like other
MS applications, is intuitive and easy to learn.  My research is

When I create a subform on a main form the wizard goes through some steps one
of them being the control?/field? that will link the two forms.  So every
time I add a record to the subform it automatically populates its record with
that field.  Now I have a button that opens a ...

How to disable close(X) button of Internet explorer pop up window
programatically?

I have a continuous form. Each record contains a field that I use to display
the label of a button that belongs to the detail section and  triggers a
specific macro (whose name is in another field). If the field is empty I
don't display the button at all.