Hi I'm embarking on my first database and hoping to learn as i go.
My first query is on forms and new entries.
I have a form for inputting Crisp Brands. On the form is a Txt_box for entering the crisp brand an unbound txt box for renering the text box to ensure spelling is correct and a lst_box listing all existing crisp brands in the sytem.
As i type into the first txtbox i would like to search the listbox and highlight any matching names and then on trying to exit the first txt box have a message box pop up saying brand of crisp already exists.
I know how to achieve this in excel but access is all new to me. Any suggestions would be great
My first query is on forms and new entries.
I have a form for inputting Crisp Brands. On the form is a Txt_box for entering the crisp brand an unbound txt box for renering the text box to ensure spelling is correct and a lst_box listing all existing crisp brands in the sytem.
As i type into the first txtbox i would like to search the listbox and highlight any matching names and then on trying to exit the first txt box have a message box pop up saying brand of crisp already exists.
I know how to achieve this in excel but access is all new to me. Any suggestions would be great
check entry is new versus lst box
0 commentaires:
Enregistrer un commentaire