Recent content by Niyiomojoh

The zip is attached herewith. I dearly need a helping help for the academic project

The code is Private Sub cboProduct_Change() Me.txtCategory.Value = Me.cboProduct.Column(1) Me.NumUnit_Cost.Value = Me.cboProduct.Column(2) End Sub

I downloaded an MS Access Inventory template. In the inventory table I added a row - "Unit Cost" I also created tables for customer and sales (this has Unit cost also) I decided to do an auto-fill to fill the sales form. But it keeps throwing error 2113 - for the field. I tried to debug but...

Thanks for your response. The reason for wanting the drug to show text is because of the report. I'm trying to view a situation where in the report you actually know the particular drug sold. In the attached report it shows number

So, what can I do to rectify that. So that the column can show text and not Number? I need a help for this project.

Thanks June7, the subform reference a table. I observed that while the subform retain the text value of the drug column, the Table under the same column only shows Number. Kindly help. I've attached the db. I appreciate in advance.

Thanks guys for the reply. But how can I make the Total Amount appear for printing?

my form included two tables - patient and Investigation. When I try to print the form, it would cut off the Summation and instead insert the table header. But if I screenshot it would appear (fig3). I need a help to be able to print the Total Amount whenever I print the form I just started...

: Hosting Success is costly; that's why only very few people succeed

I'm new to the forum. I'm also new to MS access. I'm a network and systems engineer But I'm willing to learn and also give back to the forum.