Search results

I have a form with a combo box to select the customers. in the relevant table field customer the customerID is being filled in, I want it to be the Customer Name. Is there a code I need to enter into the After Update Event of the combo box to remedy this?

Thank you. I just wanted to make sure I was thoroughly understanding the process.

Does it still make sense to have a different table for my Internal and External processes because they have vastly different data that needs to be entered?

So create the form based on the table, and replace the default control for the field with my combo box?

Are there any other Problems that you noticed?

Thank you very much. How do I get the selection to be entered into the field I want it in? Is that basically the last step in the wizard that says store value in (blank)?

So combine the tables and add a field for Precious or Base?

That is what I meant. I want a combo box for example to select the customer or supplier from their tables respectively. I also want to enter all of the different precious metals, and base metals into a table and have combo boxes for them as well. I want to have as many combo boxes as I can to...

Because I assumed that Base Metals and Precious Metals needed to be in different tables. Also I am hoping that down the road I will be able to incorporate a data feed that will automatically update the Market price of each metal based on the closing price of the day before. I realize that is way...

Thank you for all of your help and understanding. I know it is frustrating sometimes working with new users. I have learned a lot from this forum, and am extremely thankful for everyone who has offered any help at all.

HI, I want a combo box in a form for data entry. Is the best method in doing this creating a new combo box in the form and linking it to a table, or using a lookup field in my table? Thanks, Conner

Here is a screenshot of my relationships. It looks complicated and clustered, but there are a lot of components. Thanks, Conner

After normalizing the tables I have started playing around with the forms, and everything seems to be working smooth so far. I believe I have all of the necessary tables and fields. I also believe I have all of the necessary relationships for things to run smoothly. Thanks, Conner

No, but I have normalized all of my tables. I now have the correct one-to-many relationships and am ready to create a new form that will not require me to hide this many commands. Thank you for your help. Thanks, Conner

How do I make the control be associated with the label? I did nothing differently with any of the controls and labels, however some are still showing up. Thanks, Conner

What should I be looking for? there is no "Quote" or "Quotation" on the list.

I have mentioned this problem before, however I did not go into this much detail. I have now realized that this is the root of all of my problems, and I need to address this first and foremost before moving on. I tried creating forms and they fell apart. You mention a new table, which I...

It is my company. I uploaded a screenshot the design view of the table with the 75 fields in question. What more to I need to include. If you could go look at it, I would greatly appreciate it. Thread "Too many fields" Thanks, Conner

vbaInet, As I am new to all of this, I have a question non-related to coding. In my screenshots, I did not necessarily intend on leaving the company logo. If you go look now, the screenshots are all gone. You saying "Nice looking company logo " made me think it was not supposed to be there...

I explained the Model, However with 75 fields I don't know how to post the current table structure.