CODEWITHSUNDEEP
ms-access
sigil
sigil

Reputation: 9546

How to make child form refresh when master is clicked?

I have two tables, WorkItem and Status. They are related as follows: Status.WorkItemID is the foreign key mapped to the primary key WorkItem.ID. I want to set up a form so that there are datasheets for WorkItem and Status, and when a row in WorkItem is clicked, Status is refreshed with the related rows.

I tried doing this by opening the WorkItem table, and then creating a form based on it. While this did create a form where going through the WorkItem records refreshes Status, WorkItem is represented as a set of text boxes rather than a datasheet, and I can't figure out how to change those text boxes to datasheets.

I also tried dragging WorkItem and Status tables onto a blank form, and then setting the properties for the form as follows:

This didn't link the two forms, though; all the rows in Status are listed, and when I click from one WorkItem row to another, nothing happens in the Status datasheet.

What am I missing?

Upvotes: 0

Views: 252

Answers (1)

Johnny Bones
Johnny Bones

Reputation: 8404

Did you open the form in Design View and set the Default View property to "Datasheet"? When you open the Properties dialog box and click on the "Format" tab, it should be the second property from the top of the list.

Upvotes: 1

Related Questions