Input forms?

[fowlerlfc]

I've got a table called parts with the following fields:
part_id
part_name
part_cost
part_complete
part_numbcomp

I have a dataentry form with text-boxes bound to:
part_id
part_name
part_cost

Later I want to be able to input data into part_complete and part_numbcomp via textbox controls. I have all the part numbers that are in the table in a list box on the form. I want to choose which part (via the listbox) and input the part_complete and part_numbcomp into the appropriate record, but I want the textboxes to be empty when the form is opened(I don't want them to display the table data).

Can this be accomplished? If so, could someone help me out?

 

[ray00]

Yes, this can be done. Just make the textboxes unbound. And then update the tables with code (using SQl statements)after the user enters data.
Hope this helps! Let me know if you need more help!

 

[fowlerlfc]

ray00,

Thanks for such a quick response. I'm assuming I should attach the code to a command button that triggers the update. My listbox is named part_id, and the text boxes are text1 and text2. Could you provide me some sample code that I could look at? It would be very helpful and appreciated!

Thanks,
fowlerlfc