E
esparzaone
Is there a way to base a combo box off of a text box. I have a linked table
and a reg table. I have made all the necessary steps so that I can data
enter into the reg table that is based on the link table. I took the reg
table and made a form through a query because I have to append the reg table
with the linked table. So when my form comes up I have
ticket (primary key)
I want to insert a row for LotNum
and Variety
brines (number)
culls (number)
packed (which is a check box)
I cannot have the lotnum and the variety have a control because it does not
like the link. I use this form to enter brines and culls but it won't let
me. So I was thinking is there a way the ticket could remain a text box and
then have a combo box fill in the varity and lotnum for just for appearance.
So when the form came up it autopopulates the variety and lotnum based on the
ticketnum. And if this is not possible any suggestions?
Thank you for your time. It is most appreciated. Zenia
and a reg table. I have made all the necessary steps so that I can data
enter into the reg table that is based on the link table. I took the reg
table and made a form through a query because I have to append the reg table
with the linked table. So when my form comes up I have
ticket (primary key)
I want to insert a row for LotNum
and Variety
brines (number)
culls (number)
packed (which is a check box)
I cannot have the lotnum and the variety have a control because it does not
like the link. I use this form to enter brines and culls but it won't let
me. So I was thinking is there a way the ticket could remain a text box and
then have a combo box fill in the varity and lotnum for just for appearance.
So when the form came up it autopopulates the variety and lotnum based on the
ticketnum. And if this is not possible any suggestions?
Thank you for your time. It is most appreciated. Zenia