Thanks, missinglinq, for the reply. Unfortunately, the product description records aren't listed well enough for the autoexpand search capability of the combo box. For example, the user will look for any product description that has the word "gloves" in it. The results will show like 30...
Forgive me if this question isn't detailed enough, but here's my problem:
I have a Main Form (frmBundles) with a Subform(frmBundleDetails). This form allows the user to build a list of products together in the Subform (using combo boxes in continuous forms view) and give this group a name with a...
I want to find a way to do the following in my database. Similarly to building an invoice of items sold to a new customer as in the Northwinds mdb, I have a main form with subform whereby the user will build a list of records/items in the subform to make a group of items with quantities and...
I currently have a database with tables similar to the Northwind database whereby I have a Suppliers table and a Products table. I also want to build a Bundles table that bundles groups of products to show a total cost for each bundle. I am planning on breaking the Bundles table into two...
I have a Suppliers table that has a field for the supplier's website link or web address. I have both a hyperlink datatype field and a text datatype field for the supplier's web address. I have designed a form with an unbound combo box that allows me to select a specific supplier. One of the...
Thanks Curtis. I was able to get that part to work without the Object error message, however, now when my Add Items form opens up, it doesn't fill in the SupplierName field. I've tried the following code on the After Update event for the SupplierPartNo field on my Add Items form (this is an...
Forgive me if this isn't detailed enough but I have a Suppliers form (Suppliers) in MS Access 2000 with an unbound combo box (SupplierNameCbo) that allows the user to select a supplier name. When a selection is made, several text boxes on the form get filled in with the related table data using...