Thanks, I don't see an "On Current" event...do I need to create it? (how?) or did you maybe mean "On Change" ?
Thank you,Synthia
Cascading Combo Box confusion... (1 Viewer)
- Thread starter Synses
- Start date
Thanks, I don't see an "On Current" event...do I need to create it? (how?) or did you maybe mean "On Change" ?
Thank you,Synthia
Definitely not On Change. You want the form On Current event and I've confirmed that you do need it.
- Open the frmLessonLearned form in design view
- Right click in the form and select Form Properties
- In the Event tab at the very top click on the ellipses of the On Current event
- Choose code builder and click Ok
- Enter Me.cboClientFacility.Requery
It should now look like:
Code:
Private Sub Form_Current()
Me.cboClientFacility.Requery
End SubYou current structure does not allow a Lesson Learned to be related to multiple facilities. To do that you would need to add a junction table between the facilities table and the lessons learned table. This would create a many-to-many relationship between facilities and lessons learned.
If you add many-to-many relationships things get a lot more difficult. I suggest that before you start on that you read up on normalization. This series is a good place to start. And I would definately get rid of those lookup fields.
THANK YOU SO MUCH!
My error is that I was looking at the cboClientFacility properties, not the form properties.
Thank you. I hope you are blessed enormously.
Synthia
Thanks, I will get on that tomorrow!!!
Thnaks, for the 'Lesson Learned" data entered to be connected for user observation/review, in assocation with the Client and the Facility that the "lesson Learned" is about/the form user selected, I think that creating and generating a report is the way to do that without changing any current designs on the form nor on the tables...sound right?
I believe you (times ten) about getting rid of the look ups and will review the info on the links you sent to see if I can find out how to eliminate the look up tables...do you think the links you sent me will show me how to do that?
Thanks, Synthia
I don't know what you mean by "the "lesson Learned" is about/the form user selected". If you could elaborate a bit more on this it might help.
No, the links I've posted do not say anything about getting rid of them. I believe in your case all you would need to do is change the Display Control from Combo Box to Text Box on the Lookup tabs of the field that have a lookup. Basically just click on each field in the tables in design view with the Lookup tab exposed and change any Display Control that's a Combo Box to a Text Box. When you change to Datasheet View the foreign keys will then be displaying numbers as they should. After this you will use queries to get the views you were getting with the lookup fields.
Last edited:
Thanks, I eliminated the look ups and created a report.
The problem with the report is that it shows lessons learned (that had been entered for one client, or for one facility) for all facilities of the client.
(example: client Exelon)
Is there a way to make it so that when the report generates a report of lessons learned it shows:
If a lesson learned was entered on the form/is shown on the table for only one facility of a certain client, it is only shown for that one facility, not for all the facilities?
I attached the revised database if needed.
Thanks for any help you can offer!
Synthia
The problem with the report is that it shows lessons learned (that had been entered for one client, or for one facility) for all facilities of the client.
(example: client Exelon)
Is there a way to make it so that when the report generates a report of lessons learned it shows:
If a lesson learned was entered on the form/is shown on the table for only one facility of a certain client, it is only shown for that one facility, not for all the facilities?
I attached the revised database if needed.
Thanks for any help you can offer!
Synthia
First I suggest you make the text format of the LessonLearned field the same in the table, form and report. A Rich Text format will allow some formatting whereas the Text Format is just text. I think you have the report field set to text format as I was seeing HTML tags.
I don't understand what you are trying to do but the joins in this query which is the record source of the report look strange to me. This is what's causing the output to have so many records.
I suggest change them to the following and see if that's closer to what you want.
I don't understand what you are trying to do but the joins in this query which is the record source of the report look strange to me. This is what's causing the output to have so many records.
I suggest change them to the following and see if that's closer to what you want.
Attachments
-
rptquery1.jpg -
rptquery2.jpg
I can't figure out how to make the join look like the join in your picture. I got to the report Lesson Learned Query Builder but am stuck there....would you please tell me how to make it
one to many from
ClientFacilityId in tblClientFacility to
clientFacilityIdFK in tblLessonLearned
the way you did it?
Sorry so ...amateur...and thank you!
Synthia
one to many from
ClientFacilityId in tblClientFacility to
clientFacilityIdFK in tblLessonLearned
the way you did it?
Sorry so ...amateur...and thank you!
Synthia
First I suggest you make the text format of the LessonLearned field the same in the table, form and report. A Rich Text format will allow some formatting whereas the Text Format is just text. I think you have the report field set to text format as I was seeing HTML tags.
I don't understand what you are trying to do but the joins in this query which is the record source of the report look strange to me. This is what's causing the output to have so many records.
I suggest change them to the following and see if that's closer to what you want.
To remove a line click on it to select it. It will get slightly thicker when selected. Then just press the delete key or you can right click on the line and click Delete. To add a line just click on one of the field names in the join, hold the left mouse button down and drag to the other field. To change the join properties just double click on a line.
Sorry, oops thought I did...
That was post #6. We are way past that now.
Thank you for your patience. Lesson learned about navigating the messages!
I had followed the excellent instructions/picture showing how to change the join lines, but it did not look like yours, it did not have the one to many symbols and I could not make them appear so I messaged you again, and you kindly replied with more specific instructions, which were what I had done, I thought, so I opened the file and guess what, now the one to many symbols on the join were visible-and looked just like yours -and it works perfectly.
Next lesson learned was: save, close and reopen after edits before asking again.
You are amazing help.
I bought/received the book ACCESS 2016 Bible. I will study and learn this month. I am so grateful for your help. If only more people in this world were this kind and generous and patient!
THANK YOU so much!
Next (and I think last) step for this database, I need to give the user an option to generate a report for just one facility. (they would generate a report (as pdf..?) for one facility and attach it to an e-mail and send it to the associated PM, engineer, etc.)
Would it be possible?
Synthia
I had followed the excellent instructions/picture showing how to change the join lines, but it did not look like yours, it did not have the one to many symbols and I could not make them appear so I messaged you again, and you kindly replied with more specific instructions, which were what I had done, I thought, so I opened the file and guess what, now the one to many symbols on the join were visible-and looked just like yours -and it works perfectly.
Next lesson learned was: save, close and reopen after edits before asking again.
You are amazing help.
I bought/received the book ACCESS 2016 Bible. I will study and learn this month. I am so grateful for your help. If only more people in this world were this kind and generous and patient!
THANK YOU so much!
Next (and I think last) step for this database, I need to give the user an option to generate a report for just one facility. (they would generate a report (as pdf..?) for one facility and attach it to an e-mail and send it to the associated PM, engineer, etc.)
Would it be possible?
Synthia
Last edited:
I just got some work rehabbing a PHP/MYSQL Web site so regretfully I won't be able to contribute much on the AWF for a couple of months. I suggest you post this question in a new thread so that it gets more attention from other forum members.
Good luck on your project.
