Allow Edits & Combo boxes

eggtimer

Board Regular
Joined
Apr 16, 2003
Messages
125
Hi Guy's

I'm a bit new at this, thought i was being clever and have now realised that I'm not as clever as I hoped

I have a simple form, I created a combo box to look up a customer ref no.
which worked, then I set the Forms allow edits properties to "No" and created an "Edit Record" and "Save Record" button.

Trouble is I cannot use my combo box to look up a record with out clicking the "Edit Record" button.

How can I set it so the combo box can be accessed without allowing the other fields to be edited.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
I would set the "allow edits" property back to yes. Then just set the "Locked" property to yes for all your fields, keeping the combo box unlocked.
 
Upvote 0
Hi Jobb

Thanks for that, I haven't tried it yet - but it appears to be common sense for someone who knows, I'm looking at it tomorrow

hopefully I'll get my head around this access thing soon, and start asking you some taxing questions
 
Upvote 0

Forum statistics

Threads
1,221,574
Messages
6,160,602
Members
451,657
Latest member
Ang24

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top