Form Create

[ChrisBair]

Trying to create a form to enter counts into a field. I am pulling the numbers from the inventory table. I want to be able to enter the physical counts into a blank field on the same form. How do i create the field without the control source going to a table?

Thanks

 

[vbainchicago]

If the physical counts are not going to be stored in a table what are you going to do with them?

VBAinChicago

http://www.jjscomputing.com

http://www.blueboxshopping.com

 

[ChrisBair]

I want them to show on the form, then create another field beside it showing the variance(the physical inventory minus the count). As soon as I place the count into the field on the form then the variance will show. Then I can create a function to update the inventory based on the count field.


Thanks

 

[vbainchicago]

You should be able to just create a text box on a form - I think by default it will not point to a table...unless you tell it to.

VBAinChicago

http://www.jjscomputing.com

http://www.blueboxshopping.com

 

[ChrisBair]

If I enter a text box. It makes it Unbound, and I cannot enter anything into it

 

[psemianonymous]

Are you in design mode or view mode? Of course you can't enter anything in design mode.

Good luck on your assignment.

 

[ChrisBair]

In View Mode, Form. I can tab to the field, but unable to enter

 

[psemianonymous]

Unbound textboxes are just ... standard textboxes. There is no reason I can think of you are seeing this behavior.

If you've just gotten started, start fresh with a new form, and rebuild it from scratch.


Oh, and the DLookup() function may help you "query" the database, though it won't help you update anything. Check the help file for its specific usage.