Sorry, I am reposting this question. The original question came up with
wrongly set system date. Slightly rephrased the question as well.
I have two lookup tables. The structure is as follows:
1.  tblCities

Is it possible to populate a combobox (just to show related data, not for
selection) on a subform. And in such a way that in datasheet view the
combobox when clicked show the data for the relevant record of the subform.
The subform is related to the mainform of course.

Ok this is going to be a stupid Q but so far what im trying doesnt work.
I am using a toggle button which when clicked brings up some hidden text
boxes to enter or view details, what I want to do is when the button is
clicked again to make them invisible I want the page to refresh ...

I am on MSAccess 2000 and I want to valid a field before going on to next
field when user inputting data.
My so call validation is just change certain input characters into space or
just remove such character.

I've struggled with this before.  It's been quite a while since I programmed
in Access.
When you delete a record from the source of a form, how do you get it to
stop showing up as #Deleted#?  I've tried Requery....  ??

I have a forma that can be open from 2 diferent forms. If the form A is open
from form Z, the form A shows all textbox. If the form A is open from form X,
only 1 textbox is visible.
How can I do this?

I would like to update the date field on a record whenever that record is
modified.  I've tried the following code which I got from MS Help without
success.  I've installed this code in the Before Update property of the
date/time field.

I have a questionnaire form that is mostly questions with yes/no responses.  
I have created several option groups with yes/no checkboxes.  When the first
checkbox is clicked all of the others get checked as well.  If yes is checked
in the first box, no is automatically checked ...

The form was working well; I was able to update the records.
I came back in the next day to work on a control panel to calll the form and
reports; the form no longer brings up the data.  
What did I do or not do to cause this phenomenon?

I insert a MicroSoft Forms 2.0 Multipage control on a form, and try to
place some controls such as buttons, text boxes, labels on Page1 and
Page2 of the MultuPage control.
When I run the form, all the controls I placed on the multipage

I am trying to insert a field from a table, however I do not have that table
as the source for the form. This is from a separate table that I just want to
add to this existing form.
Since I only want one field from the table, I do not want to add a subform

I got a form, actually it is a sub-form links to a table.
I defined one of the field as combobox links to a lookup table. I can select
the item in the dropdown list and save it to a table.
However, I would like to allow the user edit the content of the selected

I would like to be able to use special characters (i.e. ASCII 138) in the
caption property of a command button.  I tried setting the caption property
in the the porperties sheet of the button to
=chr(138)

Still have a problem that I can't solve.
In my form I have two subforms and each subform has a single combo box with
a not in list event code. The problem is that one lets me enter new
information

I have tried answers given to similar questions on here to no avail, so
maybe you can help me.
I am trying to open a form from a switchboard in datasheet view, although
when i try this it opens as a single form. I have set the properties on the