Search results

Doc Man thanks for the code, it worked after I figured out what I was missing. The fields I was trying to populate were not on the form. When I added them then it worked. I changed from you a check box to a text box based on a new field I added to my table. On this new field is where I added the...

I forgot to mention that the check box is optional for wall mount. There will be records that don't require a wall mount so the check box will not be checked and left at a 0 value. Does this change what I need to do?

I would like to know if I can control what field the check box enters the -1 value in my record depending on a value from another field in that record. In my table called workbook I have fields called, phone type which is a text field, wall and wm entry which are both yes/no fields. I want to...

This sounds like something I would like to use. How do program the combo box to automaticly drop down when you get focus?

Thanks anyway. I'll just create a new form with sub-forms based on queries giving me the results I need and place a button in my main form to access the counts.

This database is used for one system, one customer. That is why I don't need a customer field in my Workbook table. The intent is that the user will keep a blank copy of this database, when they get a job they copy the databse to the customer folder and use for that customer only.

Not really. What I am trying to do is show the amount of devices purchased, the amount of devices used and then what is left over. I have a table called Workbook and in this table I have several fields that have to do with phone configuration. The field names are "Phone Type" and Phone Model"...

In short can I display a field on a form that is not in the forms field list without using a sub-form? I am trying to show a value from a query on this form. I tried this in the control source: [qry_op500_entry_delta]![countofphone model] I get an error stating that this is not in my field list...