Combo Search

[RussG]

Hi - I used the wizard to create a search combo box on my form, i.e the selected item in the combo finds the associated record and fills the form.
This works fine, however I have created a macro to open the from in Read Only mode and in this mode the Lookup combo does not work. When you make a selection nothing happens. Is there a way round this?

Thanks
RussG

 

[ajetrumpet]

I have created a macro to open the from in Read Only mode and in this mode the Lookup combo does not work. When you make a selection nothing happens. Is there a way round this?

Try scrapping the "read-only" on your form and turning off the "allow edits, deletions, and additions" property for each of the form's controls. It sounds like the "read only" is overwriting the autopopulating of your record. It must be reading the action as an edit to the form.

 

[RussG]

Thanks for replying.

I can get the lookup to work by opening the form in normal mode but I want to make the form available to users as Read Only, I also want them to be able to use the lookup. Maybe I need to use another method.

Any other ideas anyone.

Thanks
RussG

 

[RussG]

Thought of a solution, Made a copy of the form to be 'Read Only' and locked all the fields manually.
RussG