In Access 2003, I have a data entry form with a Multi Select list box. I'd
like to attach a button which runs a macro or a query or a code that will
create a new record (as part of a many-to-many relationship) for each
selected entry. I've been figuring it would look something ...

Can anyone tell me the expression to put into the Control Source of my
subform.  I want to put the date that is in the main form into the subform.
The tables and fields are:
TblOngoing Assessment4

I have two tables. One is a list of furniture, the other a list of fabrics.
The fabric list has pictures of the fabric embedded. When you're in the
furniture list table, I created a drop down that looks to the fabric table
for it's

I have encountered an interesting problem.
I have a working form using OpenArgs to determine from where the form was
opened so I can set the controls as required.
I need to reconfigure the form to add additional controls and separate the

I have 3 fields; admissiondate, transferdate, dischargedate.  The
admissiondate will always have data, depending on whether it was a transfer
or discharge one of these will be blank.  I want to return total of days
stayed if what was a transfer or discharge

How can I encode data with more than 255 characters to DB using the Info Path
forms?

My form is going to be used on different computers with different
resolutions. I have the form set to be re-sizable and have scroll
bars. But once the user resizes the form to their liking, I'd like it
to stay that size.

I have a small problem with the tab controls in my Access 2003 database
since I switched to Windows XP. The database is designed with a yellowish
background and using Windows NT (or the "Windows classic style" appearance
setting in XP) it is no problem defining the "Back style" ...

Within the query my form is based on I have a date field called Date Adopted.
I have then added a number of expressions that calculate 14, 28, 43 and 56
days from the date in Date Added. An example expression is: Expr1: [Date
Adopted]+14. On my form I have added new text boxes ...

I have a Products table and a Sales Detail table that have a
relationship based on the Product Number.  The Products table has the
Product Number, description, etc..  The Sales Detail table has the
Product Number, qty, price, and Sale Date.

I have set up a form that has two combo boxes. One is a school list G1, G2
ETC and this is picked up from a table called school. My other combo box call
it (class list) should populate itself with school codes based on what has
been selected in the other combo box. I think I have ...

I have been using Leban's Format By Criteria for years (I loved
it!!).  Unfortunately, I have migrated to Access 2003 and can no
longer be used.  I have tried using Leban's Conditional Formatting but
it only allows for a max of three conditions.  I need six.

Help?
I have text fields in my database table and the fields have LF (ASCII
10) characters where new lines should start within the content of the
field - is there a way to get a text box on an Access form to treat

How could I enter all my data in a my db using forms to do so.  I have 4
tables, all of which needs data entered into it.  My main table would be
personal(Client) Information,  Employment table,  and two training tables.

When I create a form using wizard I add all the info from six tables and name
it data entry.  But when it comes time to enter the data the form is blank. I
switch view to designview and all the info is there but when i switch back to
form view the details part of the form doesn't ...