Displaying New Data????

[Jonathan Smith]

I am using Access 2002, with an Access 2000 File Format, in a Windows
2000 Small Business Server/Windows XP Client environment.

I have a table that consist of the following fields:

txtRecordID
cmbProviderName
txtServiceDate
txtStartTime
txtEndTime
cmbClient
cmbActivityCode
txtActivityNotes

I have create a Form for Data Input, and it is functioning fine.

What I would like to be able to do is to display in a "DataSheet" view,
on the form the following information:

txtStartTime txtEndTime cmbClient cmbActivityCode txtActivityNotes

And I would like to have the information updated as a New Record is
created.

I created a Main Form (frm302) with all of the fields, and then a sub-
form (frm302as) with the "updated fields", linking them by ProviderName
and ServiceDate -- the sub-form is in Datasheet View. However, I am
unable to create CODE that will update the sub-form as a Record is saved
on the Main Form. I tried using the After_Update on the txtActivityNotes
field, by placing the DoCmd.Requery(frm302as), but that did not work.

Any suggestions?

 

[Jonathan Parminter]

-----Original Message-----
I am using Access 2002, with an Access 2000 File Format, in a Windows
2000 Small Business Server/Windows XP Client environment.

I have a table that consist of the following fields:

txtRecordID
cmbProviderName
txtServiceDate
txtStartTime
txtEndTime
cmbClient
cmbActivityCode
txtActivityNotes

I have create a Form for Data Input, and it is functioning fine.

What I would like to be able to do is to display in a "DataSheet" view,
on the form the following information:

txtStartTime txtEndTime cmbClient cmbActivityCode txtActivityNotes

And I would like to have the information updated as a New Record is
created.

I created a Main Form (frm302) with all of the fields, and then a sub-
form (frm302as) with the "updated fields", linking them by ProviderName
and ServiceDate -- the sub-form is in Datasheet View. However, I am
unable to create CODE that will update the sub-form as a Record is saved
on the Main Form. I tried using the After_Update on the txtActivityNotes
field, by placing the DoCmd.Requery(frm302as), but that did not work.

Any suggestions?

Hi Jonathan, you might like to review your database
design. You have only a single table. You use a Main- and
Sub- forms to deplay data when you have two or more tables
with a one-to-many relationship.

The mainform displays the one side of the relationship.
Possibly the fields:

txtRecordID
cmbProviderName
txtServiceDate

The subform displays the many side of the relationship.
Possibly the fields:

txtActivityID
txtRecordID
txtStartTime
txtEndTime
cmbClient
cmbActivityCode
txtActivityNotes

The actual fields per table are determined by the purpose
of the database and individual tables. You may like to
search the Microsoft knowledgebase for information on
Normalization.

Luck
Jonathan