I have a problem with a form/subform in a home-grown database written by
someone no longer with the company.  
There's a combo box on the main form that displays members for users to
select.  When they select one, the subform is populated with the

I have this procedure and suddnely it's not working.
I'm not an expert but it was ok.
It's like this :
Private Sub Form_Open(Cancel As Integer)

Here is a question for you, we have a pretty simple database to gather
comments and suggestions from users for improvement on things around our
office, It is a form entry, a suggestion that was given is when users want to
enter multiple suggestions they are having to re-enter the ...

I have a form that is populated witha query. I would like to not allow the
form to keep forwarding to new blank records. For example there are 12
records, when you use the record controls and get to record 12, you are not
allowed to go to 13, or at least not 14.

I know this isn't the right user group, but when accessing an Access
database remotely, what clients are recommended. Something like Citrix or
Remote Desktop?
Thanks in advance.

I created couple of tables for a mattress database, the tables are not size
(twin, full, queen) specific, and i am doing this because, new mattresses are
created frequent and what i like to do, if i was to enter a part, i like my
system to distribute it by sizes, this way, i dont ...

I love the new split form functionality in Access 2007. However, I have an
issue with it that I have been unable to resolve. The datasheet view
provided in the upper portion (by default) of the form is great for
navigating the recordset, then using the detail form portion below ...

I have a combo box that has a list derived from a query.  I want the user to
only select data in the combo box and I have set the limit to list property
to yes but users can still type in anything they want.  The error message
does display stating that it doesn't match the value ...

Morning All,
Could you help me (again)?  I have created a form which lists abridged
details of all my dbase records in a continuous form. I have a control button
which, when clicked, opens a page showing the full details of the particular

I would like to create a Option Group in my form and let user to choose
multiple options to print the deferent report.

How could I populate an employees name add last name automatically once I
have selected the employee's ID.
Thank you.

So I have this data entry form with controls linked to a number of tables. I
built it today, and up til recently worked fine.
Now, I'm having a problem where all the controls in the Details section
(when in Design View) fail to appear when viewed in Form View. My Header info

I have a form with a stock list.  One field is [Dealer Allocated] so stock
can be allocated to a specific dealer - this is a combo box (combo1) for
single allocations.
I now also want to be able to update this combo box for several records in

Iam currently trying to develope a search form (frmSearch) that a user
types a value into a text box and it then searches the table
(tblCounrty) and the results are displayed in a list box. I have
attached the query to the list box but I have totally forgot the code

How Can I Resising Controls And Change There Position At THe Run Time
Note I Am Using Access XP
Thanks