I keep getting confused on how to use a combo box and prevent the wrong
field from being changed ... i.e. I do not want the HA# to be edited in
the table.
I want to create a form to edit a table (tblHANames)

I have a Combo box selecting products in a
customer price-list.
The columns displayed in this combo box are:
'ProdID', 'Unit', 'Description',

How do I create a windows desktop shortcut icon such that it launches a
specific Access form (frmMainMenu).

I have a Text Box whose record source is a field of a query.
I want to update the query field upon 'change'
What code do I need to put in the event procedure to do that?

I'm creating atemplate Form in Access. There I have a logo. Beside the logo,
I want to put the address, city phone etc., to be static, that is, always
there. The form is used to input Invoice data and from there, comparison made
to the actual verses receivables. The Form will be ...

How do I automatically close a form after exiting the last text box on the
form?  I have a code that calls a function to check the data on the form and
if the data is OK I would like to close the form.  When the line "DoCmd.Close
acForm, "frmProject"" is executed I get the ...

Good Day,  
I am using Access 97 and when my switchboard opens it is positioned to the
far left, as is my form when opened through the switchboard. I would like to
open it and have the switchboard centered maximized. Also would like to have

I keep getting an error message on my form when trying to create a new record.
The error message says -
A related record is required in the table tblCustomperProfile.
I dont know what i am doing wrong.

I am trying to have Access 97 open up to a blank record  to be filled in but
still be able to search for old records using the search or find function.  
Currently, if I set the Data Entry to yes, when I open the form it opens to a
blank record but I can not search to bring up a ...

I need to create a database of my personal information for class. What do you
suggest I use?

Can anyone give me some direction as to how to use a command button to
open the Windows Image Acquisition form?
Also, does anyone have any code that will assign/insert the path of
the image you select into a table?

I used the Create Form to generate a form for a main table.   It works
wonderfully; however, the users are working with the actual data.  If they
over type something in the wrong field, it is gone forever.  Is there a way
to have the record displayed in the form be loaded with ...

I have a form that opens another form based on a selection from a list box.
Loading the new form is triggered by the AfterUpdate event. After the new
form opens, what is the code to close the original?

For some reason, Access (2003) is no longer saving form design edits on
closing the form. This is new so I feel that some setting somewhere has been
altered. Can anyone tell me how to change this back?
Sam

Hello Everyone, I am scratching my head over this one and am hoping you may
be able to assist. I have a form where when I page from one form to the next
I would like a text boxes value to appropriately updated. What is odd is that
when I go from one record to the next the record ...