Search results for query: *

How do I populate a combo box with a list of items, that would be based on the item I chose for another combo box? thanks, jo

How would I automatically copy the sum of data in a field of one form into another field on another form? IE, sum of all the "price" fields on one form will equal the subtotal field on another form. I know how to make the change on just the form, but it doesn't make the change it in...

How do I take the value of a field in one table and have it equal the value of another field in another table? I need the sum up a group of "Price" fields and have that sum entered into a Subtotal field in another table. I have a table with the "Price" field, and in another...

Thanks for your input. But I need the field to be filled out before that record is closed out and having them click a validate button just won't be easy enough for the people who'll be using it. Isn't there a way of setting that field to be the last field to be entered and have it be required? jo

Hi. I have a field on a form that needs to be filled out everytime a new record is entered. The only problem is, I want that field to be entered last and there's a few subforms in this main form. Because of these subforms, when I set that field on the main form as a required field, it won't...

Thanks, I emailed it to you. jo

Thanks. I tried all your suggestions, and renamed the "Parts#" name to "PartsNum" but still no go. I am already using the DLookup in another database, so I know the general set up of the statement is correct, but still no go. Is there anything else I'm overlooking. I...

Can anyone solve my mystery? I can't figure out why the "parts" and "price" field aren't being filled in when I enter in the parts#. Here are the two tables involved: Parts_List - contains the lookup info; PartsNo, Parts, Price. tblParts - holds the information pulled from...

How do I either, create a date field that recognizes a 0 in front of the single digit months? Ie, 01 (January). Or what do I need to put in the query to get a report of a specific month, that has 1 in the month. I currently have it set up so the user puts in the month to generate a report...

Thanks! I used the second one, it is much easier to add to and understand. :)

How do I simplify this? <script> function calculate1() { var subtotal = (prefix.form.quantity1.value) * (prefix.form.price1.value); prefix.form.sum1.value = subtotal; if (subtotal == &quot;0&quot;){ prefix.form.sum1.value = &quot;&quot;;} } function calculate2() { var subtotal =...

Thanks again, bobbster. That's how I currently print the correct records.

Yes, I did read your suggestioned thread, bobbster. That seems to be the best solution. I just wanted to see if there's an easier way then entering in values. But thanks, that's what I'll probbably do. Thanks again, mulligh, but there doesn't seem to be a way of printing a specific record in...

Setting up a print button to print record doesn't work, it prints all the subform records for a specific main record. Thanks anyway, it was worth trying.

Never mind, I FINALLY found it. It's the Navigation Bar field under properties. Click &quot;No&quot; to make it disappear.

How do I print a selected record and only the currently displayed subform record of that selected record? It prints up all subform records of a selected record instead of just the one I currently have pulled up.

Hi. How can I eliminate the record # of # bar from the horizontal bar on a subform?