Hello, I'm having a problem since splitting our database. Data does not display properly in a form. Here is what it looked like before we split the database:
beforesplitting.pdf
Here is what it looks like now:
aftersplitting.pdf
The DSDName Lookup is where we type the first few letters of the name, then lookup the rest of it in a table and fill the other fields with the linked data. I know that the correct data is still being saved to the DSDName because I can go to the table and check it and/or print reports but I cannot get it to display in the form. The data displays as you type it but as soon as you select the match in the lookup table, the other fields get filled but this field goes blank and stays that way.
This never happened until we split the database. Does anybody have a suggestion on how to correct the display?
Thanks!
Here is the property sheet for the combo box lookup:
combo property sheet.pdf