Search results

I am trying to populate a textbox based on selection from combo box. Both fields are in two different subforms within the same form. I do see the selection from the combo box fills via debug. I don't see a value in the textbox. This is the code I am using: Private Sub...

Thanks Jdraw. I think I was looking at everything too close and under the gun. I don't know how I remembered but today I sat down after stressing and somehow it all clicked. Still working on it now will upload later on. Thanks again!!

Thanks Jdraw. I think you must be looking at the old database file. I'm a bit beyond that but still don't know what to do about the unbound combo boxes. I've been working with the database pretty much non-stop. Hopefully can overcome the rest of the issues. Still working on it now so when...

I went in and made some changes to the database. I still don't have a good understanding about the repeating fields. Also if I bind the combo boxes to a field then each time I chose something in one of the boxes the rest change to the same thing. If I unbind them then I am able to choose each...

See now I watched all kinds of videos and read all kinds of things but you have actually put it in terms that I can see and understand. From the beginning I kept saying that I had no idea what to use for my PK's and FK's because they didn't have anything other than PO and they wanted to used...

Okay so now I'm at the point where I just have to know why the form data is not saving to a new row and overwrites the other. Put some bogus information in and see what comes out. The issue I started with was that I didn't have anything to ad to tblPurchaseOrder as autonumber and use it as a...

The tblPuchaseOrder is used on the main form. Then I created 3 subforms off of that. You originally told me to pull the data "QuantityOrdered 1-5, PricePerUnit 1-5, etc. So I pulled them out and put them in another table. Now everyone is telling me to change them again... I don't have any...

I did so much research on normalization and the easiest way for me to fix it was to take it out of the flat table it was in. All data was in one table. Not sure how I am supposed to get around the multiples as that is what the client wants to show up on the form. If you can think of a better...

Sorry about that. Not sure what happened with that but I attached it again to my original post. Thanks!!

If I save the form it's not going to save all info to the table because there are drop down lists that are chosen from. I was wondering if I should save all information to a different table then print the PO's from a report. If I am way off track please let me know. Last but not least I did...

I now get a total! Thanks Boblarson. Could I update the "Total" text box with the use of a button? Just curious as to how I could/can do this differently. I did run through the button wizard but going to try to program it myself instead. I have no problems with the way it is now but would...

I went back and read through the link a few times and I think I get it. I may have to do it ten times and that wasn't what I was worried about. I thought I had to put all ten times into the control name. I now believe that I had to go in and just check on the control source name and replace...

Wow RainLover you have good timing. I opened up a new thread (http://www.access-programmers.co.uk/forums/showthread.php?p=1253844#post1253844) just this afternoon. I'll zip the database and attach it to the new thread. Thanks again!

Trying to get a total on main form from records from two subforms. I'm coming up with Run-Time error 2450 Microsoft Access cannot find the referenced form 'tblitemlist subform'.

Right now I have a flat database with too many unnormalized fields. I am trying to figure out how to break down the repeated "QuantityOrdered" 1 through 5. "QuantityReceived" 1 through 5. "RequestedItems" 1 through 5 and "Price" per unit 1 through 5. I'm not sure if they go into the same...

I did enable macros and vba but no date still showing on records even with new record. I've decided to leave the date picker.

Thanks Boblarson! I changed all to numbers that needed to be changed. I do have more forms to create but had 3 issues that I wanted worked out first. I will enable macros and vba and let you know how I make out.

I think I probably want the number upon save that way there would be no duplicates.

I did try to add information and save it but no date. I do see the little calendar next to the box and don't want to see that either. I have attached my database as asked. Thanks!

Okay. I get the date in the table and hope it passes to the form. I don't see it on the form upon opening like it did before I rebuilt the database. I showed you how the properties were set in the table and they used to pass through to the form. If there is another way to do it that would be...