combo box autofill not working

[saleemMSMS]

hi
my database has several forms and most of the forms have ombo boxes which loads data from other tables etc.
for example, i have 2 tables in a database called book (bookid, title, authorid(FK)) and authors(authorID, authName)
in the book form, i have a combo box which loads all the author names and their IDs.. (the combo box is bounded to the authorID)
the combo box was working properly and when i start entering a name, it automaticalled used to fill with the suggestions etc.
but suddenly the autofill thing stopped working.
i'm not sure why, but these facts may help u
1. i changed the layout and other settings (like colors etc) before this problem happened....
2. i applied the "SQL server compatible syntax" to "this database" (in the Access options - object designers page)

i'm using access 2007.
i tried rebuilding the database but its not working. the combo box autofill is not working... please suggest a solution

thanx in advance.

 

[Galaxiom]

2. i applied the "SQL server compatible syntax" to "this database" (in the Access options - object designers page)

I would be very careful letting Access do anything potentially that complicated on its own. Definitely maintain a very secure preconversion backup for quite a while after doing anything severe.

Access is notorious for confusing beginners by second guessing them but such a procedure could be quite scarey even for the reasonably experienced. Access does some good automation when used in the understanding of what is going on but wizards do fall over sometimes. I don't even use the split database wizard.

There are a number of things that don't translate straight to SQL Server and could well go wrong with Access stumbling on something intractible.