Can anyone help me in Ms Access Split Form?

I have three fields Country,Product, and Year in Table Cap. I have added Combobox in form for these field . I want that if one combo box value is selected it should display related record below without allowing to edit record.

[![enter image description here][1]][1]

Any help would be appreciated.

Thank you.

  • Could you be more specific? Perhaps a screenshot of your form, maybe code? – r0berts May 11 '17 at 9:05
  • Hello @r0berts, there is a table Cap and it has three field Product,Country,Year .. i use form to Create split form , i didn't add any code in that , i just turn Form.AllowEdit property to False so that no one can edit the form. In the form a Combo box is added to select country but as the edit property is turn to false i cannot select any record. so i want to make the comobo box a filter by keeing the edit property of form to false. Thank you. – wsa May 11 '17 at 10:09
  • @r0berts, in split form there is combo box in the detail section of form and datasheet below.I want that through combo box user can search record from datasheet but they cannot edit the record in datasheet. Thank you. – wsa May 11 '17 at 10:18
  • I think I understand. Can you attach a screenshot to your question with the drop down selected as you would want it to work? – r0berts May 11 '17 at 10:42
  • @r0berts, the combo box have values, when i select any value like Country to USA , it should display related record in split datasheet below. – wsa May 11 '17 at 10:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.