Been looking through the forums and learning a lot but don’t see this
particular problem addressed . . .
I am trying to update my combo boxes when new data is added.  Usually, the
updates need to happen in a form that is not the current focus.  (So that

Is there a way to pass a variable or criteria string to another database?
i.e. if a user presses the "View Linked Record" button on a form in Access
database A1, can it open up SQL server database B2 to a specific form (not
the usual opening form) and a specific record? (or ...

Trying to set up a data entry form to populate some tables.  In it I have a
sub form that is based on a query.  The problem is, on each new record, the
entire query is displayed, not just the line item that pertains to the record
that is active. I have a "Repairs" table and a ...

i have a main form and i have set its pop up property to yes and modal to no.
i work my database through this form. i view my forms an reports through
command buttons which work fine ( i have assigned a minimize-maximize macro
to reports).

I'm trying to save the calculated result of a control "=[grossPay]*.062" into
a table.  The form will only save bound user-entered fields to the table.  I
would like to have all of the data, even calculated fields saved to the
table.  Is there a way to save unbound form fields to ...

i have a list that i have 10 different accounts listed in on my form.
I have it setup so that i can select multiple options.
how do i get this list to show up in the actual table? I had to create this
list on the form itself.

Well, I figured out my last issue on my own, but I REALLY need some help with
this one...
I'm building a warranty database and have the basic structure all laid out,
all my data in neat tables and forms all made My main form for entering

I enter ID and data on form 1. It gets stored in table A. I input same ID on
form 2, for which I want a select number of fields (populated) from tableA to
be displayed, then enter data into new fields on form 2 for which they will
be stored in table B. I want the ID for both tables ...

I have two tables (one with employee data and one with Office location
data).  They are joined using the office address as the primary key in the
Office Table and the foreign key in the Employee Table.
I have created a query using all of the fields in each table.  

At work, we use a large database. In it, there are 400 records for
personnel. The table this is based on has about 40 fields.
Currently, whenever we need to print out a report with different queries, I
need to make the query from scratch. Although not hard, I don't want to keep

what  makes the text in an unbound listbox align left or center since there
is no 'align' property? Some of mine are left-justified and some are centered
and I cannot figure out why ???

I Hope you guys can help me. I need to lock a single record in a suborm. The
code I have is (in the subform)
I basically need to allow only one addition to the table, after this they
should only be allowed to edit the record, no further additions. The problem

I'd like to be able to fill-in data into an Access Form and then export the
fields to a Microsoft Word Template with merge fields setup.  Can anyone set
me in the right direction?

I am using the following code to disable the date field if the yes/no box is
null or false:
Private Sub Combo33_AfterUpdate()
Me.Ctl1st_Date.Enabled = Nz(Me.Combo33, False)

I have a listbox on a form that is not showing the data anymore.  
It seems to be associated with a particular table.  I can create new
listboxes on the form using a different table and it works fine.  I try to
create a listbox on a different form using the table in question and ...