drop down menu in datasheet

[pauljkeenan]

Hi guys

I am new to access and am finding it difficult to do some simple things.

I need to know how I can set the properties of some of the fields in a datasheet so when clicked on a drop down menu appears.

I have an add record form where on one field the user can select a number of options from a drop down menu and this is then added to the table, however on one of the following forms I have a datasheet in a subform that is set to allow edits. I want a drop down menu to appear when the user selects the field that also had a drop down menu on the add record form.

any ideas on how this can be done would be greatly appreciated lads?

cheers

 

[llkhoutx]

Just right click the field you want to change to a combo box (drop list) and select Change to | combo box from the list.

Then right click the combo box created and set it's properties accordingly, particularily the Row Source property and the properties usually associated with a combo box.

That ought to get you started.

 

[JRG2006]

Validation Rules (HELP)

I need to know what text, and how it should be entered to enter into my validation rule box, so only certain words can be entered into my table in datasheet view, and also in the form fields. Any advice is most appreciated.

Thank you,

Damsel In Distress

 

[neileg]

You can't do much in datasheet view. However you can create a continuous form that is pretty much the same thing, only much more flexible and will support combo boxes, unlike a datatsheet.

 

[JRG2006]

I know I can't do it in datasheet, I'm trying to do it in design view and use the build option for the validation rule I want. I just need to know how to word it so it will work right. Thanks!

PS...I love the Stones!

 

[neileg]

Wouldn't it be much more efficient to create a table of accepted words and use a combo based on this so that users can select the word they want, rather than letting them enter anything and then rejecting it when the field is saved?