I'm trying to have my field [ScreenedBy] autofilled when my Combobox
[Screened] is changed by the user.
I tried with this expression...
OnChange - Screened

I know it's something stupid I'm overlooking somewhere...
I have a main form frm_PBT with many text fields and comboboxes on it.
If a record comes up with cmbGroup,cmbCompany,cmbYear or cmbPeriod already
populated I wanted those fields to be disabled...

I could use a little help from a good code writer out there. I found
some code and modified it a bit for my needs but, I need a little help
to finish it up. What I am trying to due is to get a number to fill out
a text box on my form. I want it to look at the form and get the

Hi, I am trying to recreate the search for groups form here:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm . So far I have an
unbound form with a listbox on the left and a continuous subform on the
right.  My two problems are: 1. How do I open the form so that the ...

I have one table and several forms for data entry purposes.  When I add a
record and move to the next form the ID carries over, but when I add a new
record from the begining the value stays the same in the other forms. How do
I get the other forms all on the SAME record source?  It ...

I have a database with 3 tables:
1)  ProductDetails - fields are:
Autonumber
ProductType

I created a form using a query and also I have added a combo box that will
populate the  address fields for me. I noticed that at the bottom of the form
it is couting the number of Addresses in the query instead of starting from a
new record. In other words the count at the ...

I have two subforms on the same tab.  Both of them use the same table.  They
are supposed to be linked to each idividual contact in the database.  Each
time a new line is made in the first subform when I click on the notes form
in the second subform (this is the only field in the ...

I have a form setup with a subform within it.  The subform is currently in a
Datasheet view.  I would like to stop a column from being viewed.  Is there
anyway to do this?  I have set the property setting "visible" to No but the
column is still appearing.

I have two tables RFI Log and Event Req.  Both tables have the field 'Event
No'.  A RFI field is under both tables. Under RFI Log the field is named 'RFI
No'.  Under Event Req. table the are multiple RFI fields: 'RFI No1', 'RFI
No2', 'RFI No3' etc.  I also have created two data ...

I'm trying to use the down/up arrow navigation keys on a standard combo box
(ie. open combo box, scroll to correct selection and press enter to select
and close).  When I set focus on the box and press F4 or alt/down arrow  to
push the drop down, and press the down arrow, the ...

Using Access2000 for development (end users using Access2003)
I have a table of clients, T_CLIENTS and companies, T_COMPANIES. There's a
1:M relationship between the two (1 client, many companies for that client).
There's an autonumber on the T_CLIENTS table.

I have two forms and I want the user to be able to switch back and forth
between them.   The forms use data from the same table and from only one
table.   I have a button working on one form to go to the other form and to
'stick' to the record the user is on.   But, when I try to ...

Hi,
Is it possible to create dynamic controls (text boxes and labels) on an
Access form. The Access help only mentions ControlBars, although VB allows
for more controls.

I am using a Tab Control and moving a set of fields/labels into the Page
section of each tab.  I am finding that each Page is 'forced' to be the same
Height) as the tallest Page?  I would like to be able to shrink/expand each
Page to fit the size of the group of controls I move ...