Recent content by rhernand

Each combo box record source is a table, Dept table, Div table, etc. The column count is two; DeptID, Deptname.

I have an Employee table and sometimes needs to be updated if an employee moves to another department. I wrote a query that will select all of the employee's data. I want to use a View/Update Form that will display the employee's data, Department, Division, Cost Center, etc. However, each of the...

RI Worked Great thanks RI Worked Great thanks

I have a Form that I use to view records from a Main Table. The records have an Autonumber. I also have a Remarks Table that contains remarks for each record in the Main Table. The records in the Remarks table records also have an Autonumber for each remark and save the Autonumber for the Main...

Worked Great Thanks Worked Great Thanks

I have a Form that I use to insert records to a table. The STATE field is not on the Form, but needs to be populated on the table based on the TOWNCODE field that is on the Form. If the TOWNCODE entered on the Form is > 20 then the STATE is 2, else the STATE is 1. How can I do this?

I problem is the table data. Not all the columns I am serching on have data(empty). This is Jon's last statement: "Unfortunately, the Like operator cannot return Null values. So when the text box or combo box is left blank, it fails to return all the records if the field happens to contain Null...

oooooooooooohhhhhhhhhh I now understand that I can not have empty columns in a table for a search. I have put a default of "Unknown" on all text fields and 0 for all numeric fields. Thanks

I have a Search Query based on a Form. It does not retrieve any columns from the table if any column is empty. Why? I thought the & "*" would find all records. SELECT DISTINCT LITE.OWNER, LITE.LAMP_SUFF, LITE.LAMP_NUMBER, LITE.TOWN_CODE, LITE.ACCT_NO, LITE.STR_NAME, LITE.STR_DESC...

I did have Page header footer, instead of Form Thanks

I have a Combo Box based on a table list on a Form. I want to choose several items from the list to feed a Lookup Query. Can this be done? :rolleyes:

I created a Form with a Header and Footer. When I see it in Form View, it only displays the Detail records. Why?

Thanks again

Nevermind, I missplelled Me.TxtEmpNum=Me.cboEmployee.Column(3), should have been Me.cboxEmployee. Thanks it works fine

I had forgotten that, it was Column(2) that I wanted. However, I still get the compile error. Is the Text Box bound?