Recent content by gizmogeek

Okay, great! Thanks :)

I did not copy and paste I filled in my info but do not have the extra fields that you have an was wondering if you were using them to hold the number in one of the fields until update to ensure that no one else pulled that number.

I need some help with DMax multi user. I don't get a PO number and when I click on my subform I can't change the values because it says I need to add multi user. Also code that Chris O and RainLover had references additional fields which I don't have. I only have the one field that needs...

Would I be able to accomplish this if I took the 5 subforms out, related each table to the main table and added the 5 items quantityordered, totalinventory, requested items, etc... right on the main form itself? If so do I create quantityorderedID, totalinventoryID, etc... in the main table to...

Thanks for replying. I don't mean to be rude but it took me forever to normalize the database and on instruction from a few in this forum I took all of the 5 fields and broke them up into their own separate tables. So I have 5 places on my form that are order fields. Meaning I can order up to...

Thank you for replying. I'm not really looking to redesign as everything is working the way it should. I am trying to accomplish/minimize end user input by updating 5 records in one shot. For instance: I want to see one field on the form called "Price". I want the value of whatever is...

It looks like this issue is only for the subforms. If I bind them to the main form will that solve my issue? If so, how can I accomplish this?

Is there a query or something that I can have behind the form that when I update 1 price on the form it's actually updating all 5 behind the scene? Not prepared to invent the wheel today :)

I have all 5 instances in one table now they had it all in one before. There are 5 instances of 5 different things so I had to break them all out into seperate tables.

could just the db be deleted later?

sure I have a database with price_1. price_2, price_3, etc... I want to update the whole row at once with the same $ amount. So say I am updating a supplier and his milk is $5 I want that price to appear in all 5 instances for that record.

Thanks Monardo. Now looking at this I have a form with 6 subforms. 5 of the subforms are already populated even with the DoCmd.GoToRecord acDataForm, "frmPurchaseOrder", acNewRec in the onopen event. I tried to put it on the subforms but then they are all blank without cells or anything...

Thank you! I already have that code on the cmdNew_Click. I think my problem resides with the subforms not being blank anymore. Should I put the code on the subforms? Private Sub CmdNew_Click() DoCmd.GoToRecord acDataForm, "frmPurchaseOrder", acNewRec End Sub

Yes Monardo that is correct. I want the best of both worlds. I can't help but to think others have run into this because my problems seem like they would happen to many others.

I want to be able to use my record selector and see past records "in form view" but when I open a new form or select new form the records are already populated with the last transaction that took place. I'm no so sure I'm explaining it right. If I set the form data entry to "yes" then I can't...