Creating a New Record

[chappie2]

I need some help with writing a macro or code to either open or create a new record in the following situation.

My Grants application has three tables:
grantsum contains information on all grants;
FTrack is for tracking the fairly simply process of awarding formula grants;
CTrack is for tracking the much more complex process of awarding competitive grants.

There are one to one relationships between grantsum and the tracking tables.

I have created a form with the grantsum information. I would like to use a command button on that form to a) open the associated tracking record and b) create a record in the appropriate table if there is no tracking record.

Can someone give me some guidance on where to start on this?

Thanks.

Lloyd

 

[Rolliee]

Lloyd,

It sounds like you would do well to create a JOINed query with the main table the Sum table and the JOINed table the subordinate table. Then let the 'wiz create a form with that query.

An alternate would be to use the Sum table at a main form and use a a subform to tag all the child references to the mainref.


Rollie E