473,386 Members | 1,606 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Select a field in a form blanks(Greys) out and restricts other cells.

Hello

I have created a from that has a few combo boxes that are linked to a sub form,

If i select a combo box to find a record i want to grey out and restrict access to the other combo boxes.

Please help

Thanks

Imran
Jan 13 '10 #1
1 1090
nico5038
3,080 Expert 2GB
Just add to the code of each combo's afterupdate event:
Expand|Select|Wrap|Line Numbers
  1. Combo1:
  2. me.combo1.enabled = true
  3. me.combo2.enabled = false
  4. me.combo3.enabled = false
  5. Combo2:
  6. me.combo1.enabled = false
  7. me.combo2.enabled = true
  8. me.combo3.enabled = false
  9. etc..
  10.  
Of course you'll also need a button to reset all combo's....

Nic;o)
Jan 13 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

23
by: ian justice | last post by:
Before i post actual code, as i need a speedyish reply. Can i first ask if anyone knows off the top of their head, if there is a likely obvious cause to the following problem. For the moment i've...
1
by: selen | last post by:
Hello Can I select the cell in datagrid? and can I read its text. I cant do it asp.net in c#... Thanks
0
by: Thomas Scheiderich | last post by:
I have a screen that just takes a phone book entry. In the Cell Phone question, it checks to see if the field has changed. If the field is no, it disables the textbox and greys out the label. If...
1
by: Mark Goldin | last post by:
How do I merge cells in a table? I am selecting two cells, but Merge cells is disasbled in a Popup menu.
1
by: jason.teen | last post by:
Hi, I'm having trouble using the blank/empty cells as valid values in a join. I have noticed that MS Access doesn't allow you to join with a blank. for eg. Des | val
4
by: ielamrani | last post by:
Hi, I am getting this error when I try to export to an excel sheet. When I click on a button to export the first time it's fine, I rename the exported excel sheet and I try to export it again and I...
0
by: diogenes | last post by:
"Rick Brandt" <rickbrandt2@hotmail.comwrote in news:bPnKj.456$%41.325 @nlpi064.nbdc.sbc.com: I used this approach, and it works a treat! ID In(SELECT Order_ID FROM orderitems WHERE NAME =...
4
by: GLSmyth | last post by:
I need to select cells from one table that do not appear in a second table. I know that this can be done in some flavors of SQL by using Except: Select Unit_PK From Table1 Except Select Unit_PK...
2
by: Stratocaster | last post by:
Hello, and thank you for any help in advance. I need help determining if any commands exist in VB (Excel macro style) that can enable a user to select cells and run a macro which performs...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.