Auto Populate my Form?!

[Colmans]

Hello everyone,

I am attempting to build a database for a business but I have stumbled across a problem. The user of the database will submit the customer's order via a form which will then obviously appear in the table. I have got all of that set up and I am happy with it.

However, on the form there are three fields which are causing a problem; ItemID, Order and Price. I watched a video on YouTube which I found very useful and beneficial for a database (https://www.youtube.com/watch?v=rSPS24EfijI) and I had previously used this video to build a friend's database this way, and it worked for them but it doesn't for me.



All in all, when the user selects an ItemID from the drop down box on the form, I want the Order and Price text boxes to populate automatically as they will all link. I know it works because as I said I done it for a friend, but for some reason it isn't for me.

I will attach my database down below.

Orders1.accdb

Many thanks and I appreciate all answers,
Colmans

[davegri]

It works fine as is. Exactly like what you described that you wanted.
As an aside, your 'TotalBill' field in your table is long integer, so it will not show any decimal places.

[Colmans]

It works fine as is. Exactly like what you described that you wanted.
As an aside, your 'TotalBill' field in your table is long integer, so it will not show any decimal places.

It works?! Well why doesn't it appear for me? I've attached an image of what it looks like on my screen. Can you do the same with your screen please??



Those fields should have information in them!

And thank you regarding the "TotalBill" field!

[davegri]

Attachment 26549

Don't know what to say. Works fine for me.

[Colmans]

Attachment 26549

Don't know what to say. Works fine for me.

And are you using Access 2016??

[Missinglinq]

And are you using Access 2016??

That's what it states by his user name, and, like you, he's also running Windows 10!

Does any code work for you? If not, you probably need to declare the Folder the file resides in as Trusted...which might explain why it works for your other db but not this one.

Linq ;0)>