Hi,
I've got a combobox of a for which looks up data from a table and add the ID value to the underlying table on the form. This has been working fine for aout six month, and just recently it seems to have stopped working.
The form is based on a table which has several feilds including one called "ProoferID" which is a number.
The combobox is based on a table with "ProoferName" and "ProoferID" which is the Primary Key and is an autonumber. The Row select property is
SELECT [TblProoferName].[ProoferID], [TblProoferName].[ProoferName] FROM [TblProoferName]
The properties are
Column count 2
Column Heads No
Column width 0cm;2.54cm
Bound column 1
List row 8
Control source ProoferID
The database has the Tabels on a Access 97 backend, and a 2K Front end. I've recreating the combobox but it still doesn't work, but when I set it up in 97 it does work, it looks just the same.
What is happening it for entries allready made the ProoferName isn't showing, and when you try to select one it flashes quickly then disappears.
Have you any suggestions on what is causing this and what I could do to sort it out.
Thank in advance for your help
Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.
I've got a combobox of a for which looks up data from a table and add the ID value to the underlying table on the form. This has been working fine for aout six month, and just recently it seems to have stopped working.
The form is based on a table which has several feilds including one called "ProoferID" which is a number.
The combobox is based on a table with "ProoferName" and "ProoferID" which is the Primary Key and is an autonumber. The Row select property is
SELECT [TblProoferName].[ProoferID], [TblProoferName].[ProoferName] FROM [TblProoferName]
The properties are
Column count 2
Column Heads No
Column width 0cm;2.54cm
Bound column 1
List row 8
Control source ProoferID
The database has the Tabels on a Access 97 backend, and a 2K Front end. I've recreating the combobox but it still doesn't work, but when I set it up in 97 it does work, it looks just the same.
What is happening it for entries allready made the ProoferName isn't showing, and when you try to select one it flashes quickly then disappears.
Have you any suggestions on what is causing this and what I could do to sort it out.
Thank in advance for your help
Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.
