I have a form called frm_Vendor.  I have multiple required fields for saving
a record.   How can I enforce that all fields must be entered in order to
save a new record?  I have the Required Property set to Yes at the table
level also.

I have a subform the opens in datasheet view by default.  I want to allow
only custom shortcuts , but if you right click on the column header, a
shortcut menu with options Subform, sort asc, sort desc, copy, column width,
hide, freeze and unfreeze,  pop up.  I do not want to allow ...

I just read in the help file "Setting it to No by using Visual Basic is
equivalent to clicking Remove Filter/Sort on the Records menu"
the default for my form is DataEntry=True. I would like to set a Toggle when
the form is open already so that if the search box i have on the form ...

I am using a form for data entry which is bound to tlbLetter.  After entering
a loan number in a field in the form , I want a message box to tell me if the
loan number is in a different table called tblImport.  Can someone help me
with the code on this?  Thanks...

I have set up a query to auto fill two fields.  The query is working
correctly but I need to know how to change the record source of the two
fields that are to be auto-filled to the query instead of the table all the
other fields are based on.  Any ideas?

I am using ACCESS 97 and have been completely self taught (and only a
novice) so I am not fully aware of all of the correct terminolgy when it
comes to ACCESS.
What I am trying to do is this:

hello, I build a little and easy database but the users would like when they
are done with the form, once they save the entry, that a field stays (
dropdown ). It is a "Name" field so they wont have to relook for there name
every time. How can I make that static ?

In forms view, how can I choose more than one multiple choice. Right
now I set it up in a list form in the table. I was unable to pick more
than one of the choices. Can you help me? Thank you in advance.

-- Hi
I would be very grateful if you could help me with a couple of issues I have
with access forms.  If you can help me please can you explain what I need to
do in a basic language as I have never done VB.

A form is based on a query with many (15) fields. Placing fields from the
query onto the form is extremely slow.  Selecting a field on the form,
dragging a field to a new location on the form, and similar operations can
take 10 to 15 seconds to redraw.  Any ideas why this may be ...

I have two command bottons on the forms
1)
Private Sub Save_Click()
Dim Answer As Integer

How would one make access display an image from a website based on
another field in the same form?
here's what I'm looking to do. I've got one field that has an id
number. Let's say for example that in this particular record, the id

I have a form with a subform and a nested subform within the subform.  In
design view for the subform, I can see the nested form but when I switch to
Form View, I can no longer see the nested form.  Where did I go wrong?

When writing the VBA code, how do you refer to a child form when there are
more than one on a form?
My parent form is called frm_Vendor and the subform I need to reference is
called subfrm_Application.   I am trying to create a business rule that says

I have a colored background and set the Back Style property (Tab Control) to
Transparent but it wont work.