Replies

If I delete the relationship then the table, it disappears and does not return. Thank you – your question contained the solution.

Actually, only the original form is bound to the table. The second form is bound to a parameter query that searches the table for whatever the user inputs in the parameter dialog box. The result is displayed in the form. The problem is that the subforms do not display any data. I suspect this is due to the fact that the original form (which I copied when I created the second form) was bound to the table. The original form, by the way, works very well for entering new jobs and viewing other jobs. I had hoped I could use the original form to do a query by example but I found that when I type in an existing job number in that control, it is rejected because the job number already exists. So, the only way I could do it (limited by knowledge and experience) was to construct a parameter query and display the results in the second form which I bound to the query.

I admit it is a clumsy design and I will get better as I learn more about Access and databases.

Actually, only the original form is bound to the table. The second form is bound to a parameter query that searches the table for whatever the user inputs in the parameter dialog box. The result is displayed in the form. The problem is that the subforms do not display any data. I suspect this is due to the fact that the original form (which I copied when I created the second form) was bound to the table. The original form, by the way, works very well for entering new jobs and viewing other jobs. I had hoped I could use the original form to do a query by example but I found that when I type in an existing job number in that control, it is rejected because the job number already exists. So, the only way I could do it (limited by knowledge and experience) was to construct a parameter query and display the results in the second form which I bound to the query.

I admit it is a clumsy design and I will get better as I learn more about Access and databases.

Thank you Hans. My knowledge of Access & VBA is too limited to fully understand your answer. I did copy the form and change the record source to the query instead of the table. The problem I have now is that the form has two subforms that are both linked to the original jobs table. Since I now use the query as the record source instead of the table, the subforms do not display any data. What did I do wrong? How can i correct this?

Thank you Hans. My knowledge of Access & VBA is too limited to fully understand your answer. I did copy the form and change the record source to the query instead of the table. The problem I have now is that the form has two subforms that are both linked to the original jobs table. Since I now use the query as the record source instead of the table, the subforms do not display any data. What did I do wrong? How can i correct this?

Thank you – that works. However, I have one subform in datasheet view and I notice that it does not display any header. I am trying to distinguish on the datasheet view data elements associated with the job input and the job output. I was hoping to somehow be able to either use headings or colors to show the difference. What would you suggest. Below is an approximation of what I want (dots & dashes used only for spacing in this post – I can seem to use spaces or tabs). The INPUT & OUTPUT are the headers I want – the other field names (labels) are done automatically in datasheet view.

…………………..INPUT>>>——————–>>>OUTPUT
Line#… Medium Density tape#……. Medium Density Tape#

Thank you – that works. However, I have one subform in datasheet view and I notice that it does not display any header. I am trying to distinguish on the datasheet view data elements associated with the job input and the job output. I was hoping to somehow be able to either use headings or colors to show the difference. What would you suggest. Below is an approximation of what I want (dots & dashes used only for spacing in this post – I can seem to use spaces or tabs). The INPUT & OUTPUT are the headers I want – the other field names (labels) are done automatically in datasheet view.

…………………..INPUT>>>——————–>>>OUTPUT
Line#… Medium Density tape#……. Medium Density Tape#

I was wrong about not entering data – I fixed that.

The effect I was looking for was to have a form with three tabs at the top – like index cards. The first tab (for the main form) would say jobs, the second & third tabs wouls have appropriate captions. Maybe I misunderstand the subform concept but I have this type of multi-tab construct in other Access applications and I like the appearance.

I was wrong about not entering data – I fixed that.

The effect I was looking for was to have a form with three tabs at the top – like index cards. The first tab (for the main form) would say jobs, the second & third tabs wouls have appropriate captions. Maybe I misunderstand the subform concept but I have this type of multi-tab construct in other Access applications and I like the appearance.

Okay, thank you – so far no success. When I did that I had two undesired results:
1) They still appeared as a tabbed box on my main form when I wanted to only see the tabs at the top and not see the subform until I selected the tab – then the mainform would be replaced by the subform.

2) I was unable to enter data

I suspect I don’t have it set up right in terms of subform relationship. All the forms are based on tables and all three tables involved share a common field – job_Number. I set up a one-to-many relationship between the job_number fields on the job table and each of the other two tables.

Okay, thank you – so far no success. When I did that I had two undesired results:
1) They still appeared as a tabbed box on my main form when I wanted to only see the tabs at the top and not see the subform until I selected the tab – then the mainform would be replaced by the subform.

2) I was unable to enter data

I suspect I don’t have it set up right in terms of subform relationship. All the forms are based on tables and all three tables involved share a common field – job_Number. I set up a one-to-many relationship between the job_number fields on the job table and each of the other two tables.

Hans, I like the idea of using tabs. I added a tab control but it shows up as a small box with two tabs… I have already created the subforms, how do I add then to the tab pages? Also, How do I make the tabs appear at the top of the main form instead of a small box inside the main form? See the attached picture for what I am talking about.

Hans, I like the idea of using tabs. I added a tab control but it shows up as a small box with two tabs… I have already created the subforms, how do I add then to the tab pages? Also, How do I make the tabs appear at the top of the main form instead of a small box inside the main form? See the attached picture for what I am talking about.

Thanks for the offer, Ron. I sent you a private email.

Thanks for the offer, Ron. I sent you a private email.