Recent content by danny westman

I'm trying to use the date picker on my form but it won't appear in form view. I understand that the attribute exists at both table and form level and I've tried all combinations: removing the attribute from the table, from the form and keeping them both present. Oddly, I've written another...

Great...a little confusing but I get the idea. Thank you Galaxiom!

Thanks Galaxiom, that worked. So, in the end I have 2 queries and 1 subquery that are 3 separate objects. I can hide the first 2 and just display the 3rd which contains the result but is there a way to nest these into 1 query?

I have a query that takes 2 junction tables and uses a calculated field to come up with an on-hand count. Unfortunately, I'm getting multiple values for each product code when I simply want one count listed for each product ID. Here is what I'm using for my calculated field: On Hand: [tbl...

I answered my own question, it's not necessary with the existing relationships. Thanks Bob!

Thank you Bob! That makes sense and keeps the control in the definable objects and not in the tables themselves. This type of reference could also work for the Sales Order ID field on the subform, correct? Instead of having the user enter that number more than once on the main form then...

Hi Bob, thanks again! Yes, you're correct that I'm using table-level combos and drop-downs and didn't realize the potential issue here. Please take a look at my DB and see where I'm going with this although I think your solution is the correct one which I'm working out now. I'm curious about...

Thanks Bob. I'm a bit confused with your solution because I'm working with a table (junction table actually) within the form so I can't add additional fields here but only edit the field properties from the junction table itself which includes the description field. If that is still workable...

Thanks for the reply Mark! Actually, I have a combo box already set for the product number and though I could use another combo box for description, I'd rather have it populate automatically based on whatever is selected for the product number. That way, I don't get a mismatch between products...

Hello all, I am a new Access user and I have a form that uses a junction table within the form as a subform or perhaps a subtable. In this subtable, I would like to autofill one field (description) based on the value chosen from another field (part number). The part number field is a drop-down...