Can't reflect changes table-forms

[graciemora]

Hi I'm creating my first database, a have mi tables, but I need an input form. I had the relationship set up. but I would like to know why when I change de data type on my form# field from number to Autonumber in the table is not reflect on my form. I know only form and queries can contain calculates fields, so what I Did, have a table called over/short transaction table, from this table I create a query from that table to add a total field that calculate the total amount; Total:[Price] * [Quantity] , and after that I create a simple input form coming from that query. the name of tables: Itemstable, Customertable, EmployeesTable, Departmentstable, Data EntryTable, and MY Input table Over/short on this table i will get information from the other ones to populate my input form. please help me is there another easy way to have an input form.

[Rainlover]

Try deleting the field the put it back again.

[graciemora]

I did that on my table but does not reflect on my form. ( that field is a primary key) and I dont know see the primary key on my form

[Rainlover]

I meant to delete it on the Form.

The control on the form must have the same Control Source Name as that of the field name from the table.

Are you getting an error message? If the names are different you should be getting #Name or something similar.

Are you sure you are talking about the Primary Key on the form or do you mean the Foreign key.

Are you getting your record Source directly from the Table or a Query.


If it is a Query check to see if it is working there properly.

[graciemora]

hi Rainlover, yes, I created a table first named "over/short table,' and then a query from that table; named over/short query. on this query I add a field named total: [price] * [qty] and then from this query I created a form because I need the calculate field, but I forgot to add a Primary key to the table, using autonumber data. so I went back to the table and add the primary key to the field named Form# but is not showing it on the query and not showing on the form either. No I am not getting an error message.

[Rainlover]

Change this "over/short table" to "over_short_table"

Not sure if it will fix it but worth a go.

[Rainlover]

Can you post those two table in a small Accesss 2003 Database.

I think I know the answer but not 100% sure without a proper look.

[graciemora]

THANKS FOR YOUR HELP IM SENDING YOU A COPY OF MY DATABASE, PLEASE I NEED HELP I BEEN WORKING ON THIS FOR MORE THE 2 MONTHS let me know if you received it's my first time using this attachment

[Rainlover]

It is not attached.

You should zip it first. Make sure it is Acccess 2003.

You also need to go to advanced,

[graciemora]

i have access 2007 Is possible to convert to 2003? sorry but i have not idea what zip means

[Rainlover]

I would think you could use File Save as to convert to 2003.

Try using Windows to send that 2003 fileto a compressed file. Zip is the most popular compression tools. Failing that use help or Google. I am sure you willl get your answer there.