sub forms and data entry

[kickitt24]

Helllo I am new here so forgive me if I don't say something right. I have never worked with access before.
I had an assignment to create a database for campus police to log cases.
I work mostly in oracle SQL and PL/SQL but I had a rough idea of how to go about it. I have been reading and watching tutorials for about 3 weeks.

I have a main table for the unique case info (case #, date, time, responding officer etc) and case # is set as a primary key.

I have 4 other tables that could contain multiple items for the same case #, i.e. offenses, suspects, complaintants, witnesses. (joined to main table in a 1 to many relationship)

I put 4 poop-up subforms on the main form for these. (I was trying to save space)

Everything works fine but they don't want to have to re-enter the case number again on each of the subforms.

How can I carry the case # entered on the main form to each of the sub forms as they get to them.

When I was experimenting with just one subform (and leaving it open) I could be mistaken but I thought the case # carried over to the sub-form. But when I added them as pop-ups they do not. I can try to up load a sample if that would help. There is no data in the tables other than test input that I put in from the forms

Also for the offenses I would like to just pop up or drop down a list and let them click check boxes beside the offenses expecially if there are more thsn one.


Thanks

 

[pbaldy]

I'm not sure what you mean by a popup subform. A subform is embedded in the main form. A separate form could pop up on top of the main form, but it would not be a subform. For a subform, the answer to your question would be the master/child links of the subform control.

 

[kickitt24]

hello Paul and thank you for responding. Good answer!
Okay I think I see what you mean. Because I was trying to save space (lots of data entry fields) I put a 4 control buttons on the main form to open the other forms, so if I understand you correctly they are not subforms any more.

I'll re-create them as subforms.

Any idea on how I can save space?

Thank you for your help.

 

[pbaldy]

Two ways are:

1) Use a tab control with a subform on each tab
2) Have one subform control on the form, and load a different subform into it when the buttons are clicked.

 

[kickitt24]

Okay thanks, I had thought about the tab controls.... I just haven't figured out how to do it. Thanks for your suggestion(s).... I'll find a tutorial on tabs.

Oh by the way.... I rebuilt the forms as subforms on the main forms and it works now.

 

[jal]

Okay thanks, I had thought about the tab controls.... I just haven't figured out how to do it. Thanks for your suggestion(s).... I'll find a tutorial on tabs.

Oh by the way.... I rebuilt the forms as subforms on the main forms and it works now.

With tab controls, I seem to recall that you have to paste the items onto it, instead of dragging them onto it.