Updating a combo box on the current form

[JackSparrows]

ComboBox Not being able to update correctly

Hello everyone..

I have a problem with my database. There is form in which i try to add a course for a particular employee.
There are different categories and each category have their respective courses. So when i open an employee details to add a particular course i seem to be stuck with something really tricky. Because when i select a category which is drop list the combo box next to it is list of courses for the particular category selected in the first combo list. for first recordset it works fine but when i move to second recordset and select a different category on the change of that drop list the first recordset is refreshed and updated with the new category selected and there by cannot add any courses.

Any advice will be of great help.

 

[Tim L]

1. Welcome to the Forum, hopefully we'll be able to help.

2. No-one can remember that your form is in datasheet view, this is the first time you have ever posted, LOL.

3. I'm going to take a wild stab in the dark here and ask you to check the Control Source for the combo (you'll need to switch to design view first). When you find that it is currently blank you'll then need to assign it to the correct column of the underlying Record Source for the table.

HTH

Tim

 

[JackSparrows]

1. Welcome to the Forum, hopefully we'll be able to help.

2. No-one can remember that your form is in datasheet view, this is the first time you have ever posted, LOL.

3. I'm going to take a wild stab in the dark here and ask you to check the Control Source for the combo (you'll need to switch to design view first). When you find that it is currently blank you'll then need to assign it to the correct column of the underlying Record Source for the table.

HTH

Tim

Hi tim,
Sorry for my bad use of english. anyway
the control source for the combo is perfectly fine and is being referred through a query. I can send you the copy of the database and then you can have a look at it.

is this any good?

Thanks for you reply. Much appreciated.

 

[Tim L]

JackSparrows,

Happy to have a look for you.

Please remove any sensitive/personal data from your database but ensure that sample data remains and check that the problem is still evident. Use tools\database utilities\Compact And Repair, then zip up the database and attach it to a reply to the conference.

Tim

 

[JackSparrows]

JackSparrows,

Happy to have a look for you.

Please remove any sensitive/personal data from your database but ensure that sample data remains and check that the problem is still evident. Use tools\database utilities\Compact And Repair, then zip up the database and attach it to a reply to the conference.

Tim

here it is...
Hope this helps.

Thanks

 

[Bilbo_Baggins_Esq]

Try looking at this and compare it to yours:

link

Let me know when you have it so I can pull it off my server.

 

[JackSparrows]

Hi bilbo,

Thanks for the sample database. but please have look at my database and any help on this will be great.

thanks

 

[Bilbo_Baggins_Esq]

I've looked at your database, and I can't even make the course drop box work after selecting a category.

It looks to me as if you may have more problems than what you currently realize.

I think it's asking a lot to debug a database which nobody here wrote.

I wrote the sample so you can examine it and possibly learn from it, how to fix your own bug.

BTW, I also think it's asking a lot to PM me and ask me directly to fix your problem for you. I spend a an hour and a half creating a sample for you to learn from, and you can't bother to examine it closely.
Part of my premise is to help other learn, not just to provide free debugging.
but that may just be me...

poof...

 

[JackSparrows]

I think you have got me wrong here I ask to look at my database not come up with an error free database. I thoroughly looked at your database but then it is very complicated because of the number of queries it executes just to add on record. and i am not an advance user And I am not good at coding in VB.


Sorry for any inconveinence caused by me and thanks for all your help.

 

[Tim L]

JackSparrow,

1. I fully support Bilbo.

2. Go back and re-read what I asked you do to yesterday, point 3, message posted at 07:07.

3. If you still haven't spotted the problem, take a look at sfrm_CourseEntry and the category combo. Notice anything, like it being UNBOUND !

4. Having looked briefly at the Control Sources I can't figure out which of the choices in qry_Entry (the Record Source for the form) should be used, but that is probably because it looks like you didn't include a suitable column in qry_Entry to record the category. So, go back and redesign your query and ensure that a suitable category field is available to the form and therefore the combo.

5. I hope that you honestly feel very contrite, becaues I feel like I've wasted time on this, and I bet others wouldn't be too happy either.

6. If it looks like you aren't trying to help yourself people will be less inclined to help you. Take heed.

Tim

 

[Bilbo_Baggins_Esq]

I think you have got me wrong here I ask to look at my database not come up with an error free database.

Almost the entire reason that databases were developed, and have expanded capacities, and capabilities is to house and manipulate error free, clean, and relevant data. I venture a guess that is the primary driving force behind the vast majority of database developers.

I thoroughly looked at your database but then it is very complicated because of the number of queries it executes just to add on record.

Your process should be much more complicated than justs adding one record.
For example, if you add a course for a particular student:
1. Shouldn't you want to make sure that student has not already taken it?
2. Shouldn't you want to make sure that student is not already asigned to it?
3. Shouldn't you want to protect against user error damaging existing data?
4. Shouldn't you want to protect against duplicated records in the assignments table?

It may seem more complicated that you envisioned, but then the sample I sent you takes those circumstances into acocunt, and not for just adding one record.

and i am not an advance user And I am not good at coding in VB.

I know this, and that is specifically why I did not code a lot of it into complicated VBA. The idea was that you could examine what it does, how it does it, step by step, easily, and compare it against what you're already doing in your's.

Sorry for any inconveinence caused by me and thanks for all your help.

It's no inconvenience. It is why most of us are here. To learn and to help others to learn.
Sometimes, a very simple change can fix some user's errors, but then sometimes the errors are more complex, and relate to structure and schema problems and end up being even more complex than the user ever really invisioned.
Such is the case with your database.
You now have a tool to help you learn.
I strongly suggest you study it. It is not the "end all be all" solution for you and there are in fact many methods, much more complex, to do what you seek, but then if I did that, it would be of zero use for you.
I suggest you make use of it.

Best Regards,
bilbo

 

[JackSparrows]

thanks Bilbo for all the effort you've put in for me. I really appreciate it. I will closely examine the sample database and try my best to resolve the problem i have with my database.

 

[JackSparrows]

Thanks Tim for your effort. Sorry for the inconveinence.

 

[Tim L]

As Bilbo says, it's not an inconvenience.

People reply to requests for help because they want to help. Howevr, if someone suggests that you try something you should make it clear that you've definitely tried what was suggested before asking for more help. If necessary you should include further details to clarify what was going wrong and what effect trying the suggested method had. In this way you are both confirming that you've taken the advice on board and are providing move evidence to help diagnose what might be wrong.

Good luck with your project and don't be afraid to make more postings.

Tim