I have a table that has a 3 part foreign key to a look up table.  How do I
implement a combo box that looks up field1, field2, field3 and descriptive
name in the lookup table and populates field1, field2 and field3 in the
target table?

I am using the Lebans '97 tooltip control for adding some richer
functionality to a form on my Access database.
However, I appear to have a problem. My endusers tend not have particuarly
good eyesight and so I have increased the default size of the list items in

I am looking to create three buttons in my form that creates three different
filters?  Is there anyway of doing this without having to manually select
fields each time?  Can I have them linked to a query or something?
Just for a bit more info...I want the buttons to filter out my ...

I have a form with a few command buttons, and one text field.  If the user
enters a record ID into the text field and presses the "Print Report" button,
a detailed report of that record pops up.  How can I link the text box to the
button such that when the user types in an ID and ...

I have a frame (fraTransaction) with 8 option buttons on a data entry from
(frmLNEX) that is linked to a table.  How do i get the option buttons to
actually show text information in the table when the user clicks any one of
them.  I unbound the frame and added a textbox ...

I posted this problem several months back and although I received a
lot of help on it, I wasn't able to get my problem resolved.  I'm
starting fresh now and would like to give it another shot.  Here is my
problem put as simply as possible:

I changed the query that ran my data entry form and now it opens up with
data populated in it.  I looked at my query and noticed that there is no line
at the bottom where i can add new records.  Is this my problem?
How can I fix it so my form is a data entry form only again?  I ...

I am creating a Browse Records form that will list the contents of certain
fields within each record.  Some of these fields are populated from lists.  I
want the Borwse Records form to just list the contents without editing.  When
I chose to make it non-editable that worked but I ...

Hi,
I created command buttons: "New record", "previous", "next", "find".
When I open the form is on the new record.
but after I enter the data, when I click on "new record", there is a

I have a database that has two tables, Leases and Payment History.  I need
the Autonumber "Lease Id" to store as a new record under a field "Lease Id"
in the Payment History table(thereby creating a new payment Id).

How can I code a form to close without saving. do not want to even save the
autonumber
Any help here will be appreciated.
Thanks in advance

I have a form which has a subform. Is there anyway to fix the length of the
column heading in the datasheet view? I can expand it when viewing but when
I close the form and open it again it has shrunk back to its smaller size.
Thanks

I am designing a research database for the R/D department. When a product
name is made (Product Name is a Field Name) it goes through success or
failure measures. Only if the product is successful does it retains its
product its name and when it is successful it can no longer be ...

I am using a combo box to ensure that during invoice preparation the right
PRODUCT ID is selected. The product ID is quite descriptive and its a text
field. At a time 25 enteries  are displayed. However the lookup database is
currently having 1000 entries and once the database is ...

Where do I control or set the location a popup form opens to?
Any help here will be appreciated.
Thanks in advance