Search results

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...

I'm looking for a way to fill out 5 records in one row in a table at once. I want to update a supplier and price per unit for supplier via a form. I have price per unit 1-5 and the price will be the same for all 5 records. Is there a way to do this through append or update query and if so...

If I filled out a form in my database I could not click on the record arrow on the bottom of the screen to look at past forms. I had the "Data Entry" property of the form itself set to "yes". So I set it to "No' and could arrow back to look at other records. However, this has caused a problem...

There's only one column in the subform cboRequestedItems so I set it to .Column(0) The value that comes back is the ItemID and not the PricePerUnit. Forgot to add that the ItemID and the PricePerUnit are both from the same table tblItemList.

Somewhat closer. Now I get the error 2113: "The value you entered isn't valid for this field" I still get the correct data when I hover cboRequestedInventory so I went in to the both tables to see that they have the correct data type. RequestedInventory is set as text. PricePerUnit is set...

I've also tried to point it to PricePerUnit control source. I do see when debugging that the cboRequestedItems does have the correct chose value but the PricePerUnit never populates and comes up with error 2465. Here is the code that I used: Private Sub cboRequestedItems_Change()...