Adding Field to a Form built on an ODBC Table

Andy26

Hello:

I currently have an Access2000 form that is built on a query that is using a table that is linked via ODBC connection. The table pulls down a list of project numbers from my company's database and shows what account they will be charged to. I would like to add a field to my form that allows me to input the project description for the project number. Is there anyway to do this? It seems simple, but I have not been able to find anything that works.

Thanks!

msquared

Quote:

Originally Posted by Andy26

Hello:

I currently have an Access2000 form that is built on a query that is using a table that is linked via ODBC connection. The table pulls down a list of project numbers from my company's database and shows what account they will be charged to. I would like to add a field to my form that allows me to input the project description for the project number. Is there anyway to do this? It seems simple, but I have not been able to find anything that works.

Thanks!

Create a new table from the linked table containing just the ProjectNumbers and then you can create new fields like a description field.

You can then create a query based on both tables.

Adding Field to a Form built on an ODBC Table

re: Adding Field to a Form built on an ODBC Table

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about