form to edit records in A table.

[it@rbi-tech.co.za]

Good day.

I have A table with 5 fields, which i have populated only 2 fields with data from a .xls which i imported into the table.



Please assist, or lead me in the right direction.

I need to fill in the remaining 3 fields with data - preferably through a ms access form. I also need to periodically add new records.

Ive attempted to design a form, with a combo box. therefore bringing up the field, and filling in the rest of the fields for the record, but i did not succeed.

Please help.

[andy49]

table structure?

Name of table and field names as they are currently would help.

[it@rbi-tech.co.za]

Hi Andy: the fields are as follows:

ID - auto number
Quantity - number
barcode - text
part_number - text
Description - text
price - currency.

(ive Hidden the ID field)

[andy49]

Did you use the wizard to create the form? This will ensure your textboxes are bound to the table

Is the record source of the form yourtablename

[it@rbi-tech.co.za]

yes Andy- I did use the wizard,

I dnt quiet understand your second question. in any given record in the table, 2 fields have been filled in already, from the xls import.

[andy49]

Can you screen print or photo your form?


Sent from my iPhone using Tapatalk

[it@rbi-tech.co.za]

attached is the screenshot. As labelled. i want to type in any of the 2 combo boxes, and edit that record

[andy49]

Thank you.

It appears I have nothing but questions so if you can download a copy of your database (zipped) it will help

If not, I need to see the data properties of both comboboxes.

In design view, click on the combobox and press ALT+Enter. On the data tab of this properties window you'll see the top two rows are rowsource and controlsource

Rowsource is where the combo gets its data from (a query or a table or SQL statement)
Control Source is where your combobox choices are stored.