Why can't I find the Link Master Fields and Link Child Fields in my subform
properties? I need to check that my forms/subforms are linked the way they're
supposed to be, since I'm having some problems.
Thank you!

On my Access form, I try to copy the value of number field TitleID to a
text field NewTitleID while adding a character to the number. For instance,
number 435 should change to A435. I have tried things like
"Me.[TitleID] = '" """A""" & Me![NewTitleID] & "'"

OK, this is driving me mad...
I have a form.  That form contains a header which has some text fields
for ID number and name.
That form has a footer that simply contains a label that says something

I need to construct a Diary type calendar within my FE/BE database
application created in MS Access, that works and looks similar to the
calendar in Outlook, to record and edit appointments for the staff of the
company I work for. I know that I can open Outlook from the ...

I hope you can help me. I have a simple database with 2 tables. (the
database is used to store lesson plans) I have created a form with fields
from table1 with a subform containing fields from table2 (displayed as a
continuous form), all works OK. I have a field in table2 called ...

Howdy from Oklahoma again!!!
I am new to ACCESS (but getting better with everyones help!) and I have
built a form that does some data updating and appending of records but the
Notification Boxes keep popping up when the action is going to Update or

I am trying to create a Form/Subforms based on the MS Access Template 2003
entitled "Contact Management". If anyone is familiar with this Template,
please reply.
I ask this question because I am an amateur with Access, and for you to have

Good day to all,
Is there a limit to the number of subforms that can be requeried on a form at
any given time?
I have a split database, where I have a main form acting as a 5 day calendar

I have a combo box on a form that when the form opens has a default value.
It has the LimitToList property set to yes. however the user can delete the
default value and then click the ok button which the sends a Null value to
the query. I can trap all this in code but I was ...

Hi!,
I am fairly new to ACCESS and have had help to get me this far with the
problem and thought I had figured it out but I am having to ask for some
assistance to get this "DoCmd.RunSQL Insert into" script to run using data

I have a list of people on a continuous form sorted according to the
surnames. On the footer of the form, I have copied the Northwind database
Customer Phone List buttons and macro which, upon pressing a letter button,
filters surnames according to the alphabet.

I have a table with a key and 4 fields.  On a form I have a combo box which
when clicking on the drop down box displays all four fileds.  When I select
the record I want only one field is displayed in the combo box.  Is there a
way to show all four fields in the box after ...

Is there a way to add records in a filtered form? I want to open a form to
let the user add orders that are restricted to the current client. I don't
want to use sub-forms because there is too much information that needs to be
entered to fit into a sub-form.  Maybe fill in the ...

using access2000 windows 2000
I am trying to find a specific record by on a subform by selecting a value
in a combo box on the main form. I have several form in  other access
application that do this and cannot figure out why (on this new form) it

i'm trying to create a database of Staff names and contact details. Due to
the nature of the form it has 103 individual toggle buttons on it which each
represent a different building. What i would like it to do is that when the
form is filled out i can use the toggle buttons the ...