Creating a form

**Srin** · 08-28-2015, 01:54 PM

I have a table that lists the status of projects in the Status column. I want to create a Form that displays a set of details based on what the Status is for each specific project.

For example, If the status of a project is "in discussion", it should show a form that displays information that can be entered for the discussion region.

**June7** · 08-28-2015, 02:05 PM

Really need better understanding of your data structure.

Is it like:

tblProjects
ProjectID

tblStatus
StatusID
ProjectID
StatusCode
StatusDate

Then maybe you need another table:

tblStatusDetails
StatusID
Comment
CommentDate
UserID

**Srin** · 08-28-2015, 02:17 PM

There is a separate table that has the status and their ID

**June7** · 08-28-2015, 02:21 PM

That didn't help much. If you want to provide db for analysis, follow instructions at bottom of my post.

Creating a form

Thread Tools

Creating a form

Similar Threads

Creating Form to Target Current Record Open in Another Form

Creating a search form that opens a record in form view in edit mode

Creating an Assembly Form to transfer to Quote form...

Creating a form within access that updates another form?

Default form layout when creating new form

Tags for this Thread

Posting Permissions