RECORDSOURCE FORM NEED SMART PERSON HERE PLEASE!!

[sbornstein1]

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. The reason is it wont let me drop changes and I get stuck in a loop.

 

[charityg]

I don't know if this will help, but can you use more than one string? Like

strFields="Select field1, field2 from table"
strWhere="where field1='something;"

me.recordsource=strfields & " " & strwhere

Just a thought