importing a form

[MrBitsy]

I have developed a form and emailed it to a client. They import the form
into their database but it doesn't work - it doesn't appear to be able to
see the data.

Their database is pointing to the correct tables in the correct databases so
why would the form not see the data? The form doesn't have to be linked in
some way does it?

I have coded the form to build a SQL statement depending on the values in
combo boxes. The form is not bound to any data, neither are any controls.

Anyone suggest why a form may not work after importing?

 

[Sandra Daigle]

Is the form based on a saved query? If so you need to send them the query
and have them import it too. Otherwise post back with more specific details
about how it doesn't work (ie what does happen?, what error messages are
occuring, etc.).

 

[MrBitsy]

The vba in the form builds a SQL statement so it doesn't depend on a query.
I will be at the client site later but from what they said on the phone the
form fails when it opens.

I'll get back if I can't solve it - thanks for the reply.

Ray Keattch.

 

[Aaron Yang]

Try copy.

 

[MrBitsy]

I'll give it a go - how does this differ from importing?

 

[Mike Painter]

I have developed a form and emailed it to a client. They import the form
into their database but it doesn't work - it doesn't appear to be able to
see the data.

Their database is pointing to the correct tables in the correct databases so
why would the form not see the data? The form doesn't have to be linked in
some way does it?

I have coded the form to build a SQL statement depending on the values in
combo boxes. The form is not bound to any data, neither are any controls.

Anyone suggest why a form may not work after importing?

Did you send them a database with the form in it after which they used get
external data?