HI , I would like to add data from a list box to query table using a "Add Data" button someone please can help. Thanks
Please see file attached (form picture)
HI , I would like to add data from a list box to query table using a "Add Data" button someone please can help. Thanks
Please see file attached (form picture)
The listbox and form textbox is not linked to the same source yet they appear to be on the same form? You would usually add the record via the form textboxes/combos, not from a listbox on the same form. I'll suspect you might be storing the same data in 2 different tables. A listbox is for selecting items you already have in the table/query that the form is based on.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.