I have an underlying table that contains two fields LeaseName and
LeaseNumber. I have a combobox on my form that when a LeaseName is
selected an unbound textbox is autofilled with the LeaseNumber
(AfterUpdate event of my combobox).

I'm stuck and really don't know how to proceed with this project, so I
thought I would see if anyone has any ideas, please.
I have a database of Inventory items that we purchase.  We are a food
manufacturing plant and what I want to do is build a "receipe" database of

I'm feeling horribly stupid at this point. I created a simple form
that is based off a query from back-end. At one point someone entered
in data and I can view this in my underlying table. In this underlying
table I can't delete a record and it seems like some security issue is

In my listbox I have 3 rows.
The most important one is row 1
So, I use the values of row 1 when I click the listbox.
Is it possible to use the values of row 3 too?

Hello,
I have the following tables...
Product (a table of available products)
Company (a table of companies)

I have two forms of different sizes named form10x7 and form 8x6 and both
forms use the same tables and resources.  I want a user to be able to select
which size form to open after loggin into the database.  Is this possible and
if so how to code this?

Basically I want to select data from one form.. that means my project will
have 3 forms opened and updated together.
In other words  form1 will have possible data (all minus data selected in
form3 ), form2 will be current data and form3 should display all selected

I have a replicated split and distributed database. front end and backends
reside on local laptops. The backend is replicated and syncs with the master
database located on the network. My problem is the local front end runs very
slow on occassions and when entering data into ...

I thought I could set an unbound object in a form using VBA just by doing a
Me.<unbound field name>.RowSource = "<Select statement>".   Apparently,  that
doesn't ACTUALLY set the field, it only queries the table to give you the
list of data in the combo field.    Once you do the ...

I deployed an MDE file on the terminal server and when I double clicked the
MDE i have the following error. " There isn't enough memory to perform this
operation. Close unneeded programs and try again.
I never had any issues on local machine.

I have a field I want to defalt to the current year.  It is going to be part
of a file name.  All I want is the year (2008, 2009).  I am currently using
the Now() function to default that value and then using format to show only
the year.  The problem then arises when the focus ...

I have a list box on a search form containing all possible bids in my
department. Ideally, there should be a corresponding detail of each bid on
another form, the detail form. Using the AfterUpdate method of the list box
on the search, it shoulld route to the detail form, with ...

I am using Access 2007.
I have a form with 3 listboxes.  When I click on the first listbox, the
second is populated with info related to the first list box.  When I click in
the second listbox, the third listbox is populated with info related to the

I have a form with combo boxes.  Based on the user's selection. a subform is
queried.  (That subform then queries another, but that's not relevant to this
question.)  The combo box for requestID has code like this:
If Me.cmb_requestid <> "" Then

I am having some difficulty geeting the RecordSet property to work.  I am
trying to use ONE form to display records differently rather than creating
separate forms and subforms.  My form is titled frmGrouping and has its
RecordSet as qryGrouping.    I want to change the Recordset ...