TechHelp

Add New Row in Subform Upload Images Link
James Hopkins
9 months ago

Hey Rickard, I have created a *Property-Based Pricing Form" that is used to update a Service Price for individual properties. But 8 keep getting a ERROR Message when I try to add a new record.

James Hopkins
9 months ago

Dan Jackson
9 months ago

Hi James. Open your form in design view and open the forms properties (The Square connecting the rulers).

Under the Data Tab, do you have Allow Additions set to No? This needs to be set to yes

Dan Jackson
9 months ago

Since you are using a subform, check *that* form, not the parent

James Hopkins
9 months ago

Hey Dan, I was still getting the same ERROR Message after I made the Changes.

Richard Rost
9 months ago

Dan is correct in that you need to be able to add records to that form. Can you manually add a record to that form? If not then your code won't be able to either.

James Hopkins
9 months ago

Hey Guys, I seen where you was talking about in the Property Sheet. But in the 'Assign Consumables to Equipment Subform', when I click the "Add" button. I get a blank in the "Consumables" Text Box " and the "Qty" Field gets skipped.

James Hopkins
9 months ago

Kevin Robertson
9 months ago

There's no commands in your code to fill in those 2 fields.

Invoicing
DLookup
Default Value

James Hopkins
8 months ago

Thanks Kevin, I found the problem. I found that the "Product Combo" had an Control Source in it set.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated