If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 Form Locks Up After Doing a Filter
Hello,
I have an Access 2003 Form that does ok until I do a Filter (right mouse click - Filter For) on a specific record (in this case client name). When I get the client information back (its a 3 page continuous form with about 100 records about the client) I may or may not change some information on the client. When I hit the "X" or try to close the form, the database locks up every time and I have to do the three finger salute. As an FYI, the database is split with the BE database on a network server, the front end on my laptop. Network connectivity / speed isn't bad. My database isn't complex. I have one FACT Table with about 20 lookup tables joined to it. About 500 records in the database. The FACT Table has about 60 columns in it. Most of those columns join back to a lookup table. Last thing. The first thing I do when this database is launched is to create a persistent connection using some VBA code. I use the vba command CurrentDb.OpenRecordset on a table that has one row and one column in it. I call this VBA code from a startup form. Any suggestions on how to fix this? Thank you in advance. Steve |
Thread Tools | |
Display Modes | |
|
|