Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-15-2014, 08:08 AM   #1
TesZero
Newly Registered User
 
Join Date: Jul 2014
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
TesZero is on a distinguished road
Combobox list change after use it

Hello.

I am doing a checklist database.

With some other data, i have a field called "Local". (combobox)

In that "Local" field i must select the place where the checklist is made.

So, i have 20 places to do checklists, and when i select one place and save the check list, i need that "local" is disable from my combobox list so i dont accidentally repeat it.

My combobox is based in a table query.

I must do 2 checklists per day for each those 20 places...

And i cant figure out how to remove those items after use them at the moarning... and have them avaible again in the afternoon.

Thanks for your attention in advance, hope someone can help me

Regards,

TesZero is offline   Reply With Quote
Old 07-15-2014, 08:18 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,311
Thanks: 537
Thanked 939 Times in 890 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Combobox list change after use it

Have your combobox row source as a table. Add an extra field to that table, "fldFlag" (a boolean field) use the after update event of the combobox to set the Flag to true for the value you select, refresh the combo so that the selected record is hidden.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 07-22-2014, 12:15 AM   #3
TesZero
Newly Registered User
 
Join Date: Jul 2014
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
TesZero is on a distinguished road
Re: Combobox list change after use it

Hello, first of all, thank you very much for your answers.

I solved my problem, maybe not in the right way, but it is working fine

So... what i done was:

I created a table with ID, Local_name, Shift1, Shift2, Shift3

then, i created a continues form with this table fields.

When i open my main form, and after select the Local in my combobox, my combobox open the Local_Form hidden, it makes a filter by local_name and depending the time it writes a "1" in the correct shift for the local_name.
After it, my combobox query (show all exept the "1" field" is refreshed
If the swift changes, it writes "0" in all fields so we can select all local_name again.

I should do it without opening a hidden form, writing directly in the table... but it is working fine and i have a lot of work to do...
i need to migrate all of this to .Net in the future, so for now... it is fine and working.

If someone needs to do it and need help, i can try to explain it better and with printscreens.

Regards,
Thank you for all,
Pedro Silva

TesZero is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a bound Combobox - One change in Combobox changes another combobox DaveBre Forms 10 08-20-2013 08:39 AM
ComboBox - check and change (or not change) reddevil1 Forms 5 12-20-2012 05:55 AM
combobox change value patatrac Forms 0 02-06-2010 07:35 AM
Change combobox ColumnCount using VBA batwings Modules & VBA 3 04-15-2008 07:19 AM
Need my combobox to accept new data (not in list) and update the list. ??? SomeGuy Forms 2 11-16-2000 06:59 PM




All times are GMT -8. The time now is 03:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World