Recent content by Phenomena

=nz(Price,dlookup("DefaultPrice","Material","MaterialID=" & materialID)) Worked, thanks! This leads me to a new question though. On my form I have a checkbox labeled "Override default price" when this is checked I want txtPrice to be editable to allow the user to enter a new price. This worked...

I have a similar setup on my form, where the user selects items in a combobox which updates the contents of other comboboxes on the form. It's not exactly the same as you but it shouldn't be too difficult to modify it to fit your needs. Essentially what I've done is for every ComboBox is have...

I'm still getting the #Name? error.

I have a control on a subform that I need to populate with values from one of two possible tables. The sub form is is populated from a table called SummaryLine. SummaryLine has a field called Price. I want the control txtPrice to get it's value from SummaryLine.Price, unless Price is empty...

Well that was simple, thanks! I have another question. I used this same method to set the control source of txtMaterialPrice to be =IIf(IsNull([Price]),[DefaultPrice],[Price]) So if Price is null, the control source uses the DefaultPrice instead of the Price. This works fine in the sense...

I have a report being generated that pulls in a bunch of data. The processed column is a boolean value. I want to be able to set the text of a label to be equal to the "material cost" for all the rows where is processed is set to false. Picture of the report: i.imgur.com/I0Y5W8X

Thanks, I'll look into it. Tried this, but it can't requery while a field is being edited. edit: Thanks, Mihail. It seems to be working perfectly now!

Right now I have a subform with a combobox that pulls it's data from a table. I want the user to either select an existing item or type in a new item and have a macro create the new table row. What I have right now works in the sense that it prompts the user if they want to creat a new item and...