Recent content by HoustonOil

I have an orders form which contains an order details subform. I want to be able to select a product name from a dropdown box and the rest of the subform (product description and price) populate automatically, which is not happening. I have the dropdown set up and it is working just fine, but...

Sorry, I should have posted an update. I figured it out. Thank you for replying though

Ok, thanks

Bob Does my ID field have to be number? My customer ID field needs to be letters and numbers ( TRI645 ). Can I use something like this? Will it cause problems?

Thanks Doc, nicely put together.

When you set up the switchboard you have to set it to "open the form in edit mode" I think you selected "open the form in add mode" which will only allow you to add new information. Go to your switchboard manager and change it from add to edit. Make sense?

Are you opening the form from the switchboard?

Ok, I created a form based on table. The form has a combo box that drops down and lists my customers. I select the customer I want and attempt to move on to the next box and an error message appears: "The field is too small to accept the amount of data you attempted to add. Try inserting or...

I am confused. You say the form will update the tables fine, but when you use the form to update it will not let you. That does not make sense to me. Does it or does it not allow you to update?

That would be great

You can sound like anything you want, or call me anything you want (including stupid) if you get this figured out for me :D I am trying to upload a copy of the database but it is saying upload failed. The file is 3.88MB, is that too big to upload?

I went in and double checked and all my relationships are labeled one to many, but I did not have enforce referential integrity checked which I do now. So the 1 and sideways 8 is showing now. Is that what you meant by something looks wrong? My products table has the price in the price column...

I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting. For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the...

Ok, I am trying and cannot get it. Do I enter the code under "report" or under "details". I don't understand, maybe I am in over my head? . . . .

I created a form that allows me to select the quote number from the combo list. How do I run a report off that form? I tried to create a report again, but failed to tie the report to the form.