You do make a good point, but the reason I am doing that is because I am using the table to update another table, and I need the LangSymbol field and *not* the Language field. I could do the update query looking this up, but it would be more complicated.
But actually, you have solved my...
The linked table is the RecordSource for the form, and some of the fields are bound to fields on the form, but others are not. When a record in the table has been updated, I want to use that information to update the unbound fields of that record as well.
I was using code like...
If a linked table is a RecordSource for a form, will Me.Recordset work? It seems not to for me. Would I have to convert the table name in the RecordSource property to a query on that table (like SELECT * from table) for it to work ?
I am proficient at both SQL and VBA, so any hint would be...
I am splitting my database so I have a backend database. It is in the same directory as the front end. The problem is, when I move them both to a different directory, but both still in the same directory, I get the error message, "Could not find file [hard-coded original path]".
Is there any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.