TechHelp

Add New Row in Subform Upload Images Link
James Hopkins
30 days 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
30 days ago

Dan Jackson
30 days 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
30 days ago

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

James Hopkins
29 days ago

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

Richard Rost
11 days 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
8 days 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
8 days ago

Kevin Robertson
8 days ago

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

Invoicing
DLookup
Default Value

James Hopkins
7 days ago

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

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated