I have a a combo box and a sub form. When someone makes a selection in
the combo box, I'd like it to pull the changes for the subform.
Here are the details:
In CompanyCombo I have the following for RowSource:

Is there a way to programatically auto maximize my form?

I understand that there is a way to disable the Shiftkey option on opening a
MS Access database.  Can anyone point me to information regarding this
capability?
Thanks,

I have a sales databse which has a form based on a query that user looks up
companies in a particular state they wish to call.  I would like to have some
kind of indicator or alarm if there is an exact match of the Company name
field to any other records in the query.  I was ...

I need to allow users to input into one field and then click a button to move
the data into a read-only field.  I set up a button with a macro that appends
the data to the new field and removes the data from the old field.  Which is
exactly what I need.  However, it only works ...

does anyone have a template which does a daily calander for cash with weekly
and monthly totals

i have a delivery database. In it i have "projects" which our deliveries are
sent to. I want tobe able to send items to different shipping addresses under
the same project number. Currently in my projects have a ship company name,
address, phone, contact 9 and other related info. ...

Is there a way to change the color of the command buttons? (i.e. from the
grey scale to say red, or blue)

I am using DCount in a form to count number of animals (Thank you Klatuu) and
this works fine. I have a lookup combo box that the DCount statement is in.
Problem is if I use the record selector to change records, the DCount remains
the same. Where or what is the 'event trigger' ...

I have a database based on surveys with 3 tables: account, contact, and
survey.  The account and contact tables are linked by the acccount id, the
survey and account tables are also linked by account id.  I have a data entry
form where the surveys can be added by selecting the ...

I have a form with combo boxes that allows the user to rank themselves.  (No
Skill, Experienced, Expert).  I have set up several other forms that allow
the user to select the appropriate rank.  However, on one particular form, it
does not allow the user to choose the rank.  It's ...

I have two tables.  First table contains fields lot and grade.
Second table contains fields lot, sample, test, and value.
I have a form for entering data.  The main form contains the lot and grade
entry and a sub fomr handles the sample, test and value entry.   For each lot

OK, I have done DLookups a lot but something is escaping me right now. I
cannot figure out the problem here so I thought a fresh pair of eyes might
help.
The following code is giving me a runtime "3075 - Syntax Error (missing

Is there a way to allow only one form to be seen and not allow the scroll
button to move you to anther form.

Is there a way to make a command button for the filter by form function?  I
don't see it as an option when trying to make a new button on my form.  
Thanks for your help!