Hi friends,
I am new to Ms Access and I am having problem of populating a datasheet form related to some field. That is I have a form that contains a field say (someID) and on the next form, it contains a subform with datasheet view. Now I have to populate the datasheet that is related to (someID) only.
Please do help me.

You need to set the Master Child properties of the Sub Form.

Right click on your subform and select Properties. On the Data Tab, click in Link Master Field, and then follow the prompts.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks Friend it works.
But I am still getting a problem.
The problem is that each time the form containing the datasheet (subform) is opened, the datasheet subform loads all the records in the database. What I need is to load a datasheet that contain no previous records.
Please help me.

I don't unerstand how this could be working and yet displaying "all" the records in the database. If the subform records are limited to the main form primary key, then the subform will only display those records related to the main form, and not "all" the records in the database. Can you explain the issue further?



mmcdonal

Look it up at: http://wrox.books24x7.com

Actually what I mean is that I want to design a form containing datasheet as subform, which I wish it to insert new data.
Each time the form is loaded, datasheet displays all the records of previously entered data.
Each time the form is loaded, I want an empty datasheet to enter new records.

Thanks,