Displaying New Data????

  • Thread starter Thread starter Jonathan Smith
  • Start date Start date
J

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?
 
-----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?
Click to expand...
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
Click to expand...

The subform displays the many side of the relationship.
Possibly the fields:
txtActivityID
txtRecordID
txtStartTime
txtEndTime
cmbClient
cmbActivityCode
txtActivityNotes
Click to expand...

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
 
Back
Top