Hello all I need your help tonight because I am in crunch time with a deadline on this project. Here is the question I am wondering if anyone has any options. Ok I have an ADP database which when I setup the recordsource I have a query that uses a * in it for example tblOrders.*. Well what is happening is when 2 users are editing the same record I get a Write Conflict. The question I am going to keep simple. The Write Conflict does not like the tblOrders.* at all. It says it cant recognize the column prefix. I cant use a query because I am building this dynamically because of a where Clause and filters. What would work is if I could write out each field name and I know it would solve this 3 week puzzle. But the problem is there are too many fields and binding it with code Me.Recordsource does not permit the size of the string. Any other ideas what I can do I am getting desperate here and I need a good solution.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RecordSource Form Help Need someone really smart
- Thread starter SeanB
- Start date
