Search results

Thanks! I caught the two auto-filling text boxes as well. Thank you again, I greatly appreciate it. Cheers!

Thank you so much! I am very new to this, so I'm sure there is quite a bit that I've done that is less than ideal--ha! I greatly appreciate you taking the time to look at my mess. Because I learn best by repition/doing things, to make those changes to my original database to get the...

Here's a copy--it's all still in the works and contains dummy data. The main form is frmAddRental. Subform is subRentalInventory. The involved tables are RentalDetails and RentalInventory

Should be. The PK of the main form (datatype autonumber) is related to the FK field of the same name (datatype number) in the subform in a 1:many.

I have a sub-form that is not displaying data when I change records on the main form. Both forms are based on tables. I've been changing records on the main form via a combo box--works great, displays everything on the main form that it should. The subform is blank--I can enter in new data...

Looks like my issue was a combination of things: tables were not normalized, and my column counts were also incorrect. With those in mind, I scrapped the original form, started over, and got it working. Thanks all for your input!

Oh, things were all kinds of messed up so I deleted the from and started over. My tables were not normalized, so I fixed that first. I also had to adjust the column count for the combo box. Using one of the methods from @pbaldy 's blog post they shared, it works now. Thank you all!

I've messed with it a bunch, but right now it's set to =[RentalRate]

Table Inventory is a list of every item we have available to rent. Table RentalInventory lists which items are assigned to what rental--looks like I forgot to mention RentalID as a field in that table. Over it's lifetime, one item can get assigned to many RentalID's, so the tables are related...

Even with that change it still won't auto-fill the RentalRate. The RentalRate does not necessarily need to be stored in the RentalInventory table, just displayed on the form so the user has it as a reference to fill out the other information.

I started another thread, thinking my tables were the culprit. It explains my set-up better.

It's set to 1 because I only want col. 1 displayed in the combo. If I change it to 4, it displays all four values (as expected), auto-fills the SetID field, but not the RentalRate field, giving me run-time error 2448 (which is what my other thread is about).

I'm working on a multiple item form where I want the user to be able to select an item from a cbo box, it autofill some fields, and the user can fill in the other fields as necessary. I got it mostly working, except one field does not auto-fill, so I'm beginning to wonder if it is how I have...

Could this be based in how I've got the form and related tables set up?

control source: =[Inventory]![RentalRate] data type is currency I may very well have it pointed to the wrong thing. But the value from that filed is what I want it to display. I've tried changing the control source to RentalRateText = Str([RentalRate]) and it will return the same error, but...

Not a calculation in this case.

Yes, there are 4 columns total: 0) record ID (autonumber) 1) InventoryID (text) 2) SetID (text) 3) RentalRate (currency) the cbo box is bound to col 1

I have a multi-value sub-form based on an Inventory table where the user selects an InvnetoryID from a cbo box and it autopopulates the appropriate fields (setID and RentalRate). It fills SetID just fine, but will not populate RentalRate with the value from the Inventory table...

Yes, it does depend on how inventory is managed. In my case, we rent costumes. So sometimes yes, the full set gets rented out. But others, it will be broken up (for example if we own a set of 16 matching chorus costumes, but the client only needs 8). While this may not be normal in other...

Before I even try to figure this out, I thought I'd ask if this is even possible. I'd like to create a Main form and a Sub form for managing a rental. The Main form would be based on a table of rental details (who the client is, the dates, etc.) The Sub form would be based on a rental...