NotInList Problem

[nicklewis]

I was wondering if anybody can help me.

i have got a table called "Product" in which it as a feild called "DateId" this feild is a combo box that is linked to another table called "Date" in this combo i would like to be able to either select the date previously entered or ad a new date. can anybody help to correct this problem?

 

[ZmrAbdulla]

Set Limit to List=No in the proprty of combobox.
Select ComboBox then Properties > Data > Limit to List
hope this helps

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[nicklewis]

yeah i have tryed that but now i have found another problem. i have realised everything works right (the code) but the problem is that my combo box is linked up to the date table which has two feilds one being "DateId" which is an auto number and the other being "Date". the problem seems to be that when trying to add new data its only wanting to add to the "DateId" not the "Date".

 

[ZmrAbdulla]

First of all change the field Name "Date" to something like "MyDate" or "PymntDate" etc.. "Date" is a reserved word in VBA.
Alter the rowsource to a single column by removing the DateID field form the rowsource. you can change it by clicking the build (...) button at the right hand side of the rowsource in the propertybox.
hope this helps

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me