|
|
Using list box adds blank record to lookup table
Hello, I have a form (frmpurchases) based on a query. My query is based on
two tables. tblPurchases (master table) and tblItems (lookup table describing
the item category). The field link between the two tables is the field
called Items.
On frmPurchases, there is a list box for selecting the type of Item. which
once selected, autofills various other fields with the Items details.
Everything seems to work fine and I have no problem adding records etc. The
one glitch I can't figure out, is everytime I add a new purchase using
frmpurchases and select the Item(list box), when I go out of the database and
come back in, there is a new blank record in my TblItems for every new
purchase I entered. So if I select the list box again, there will be blanks
in the list for every new record.
How can I prevent my lookup table from adding blank records with each new
purchase.
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/27/2010 4:22:01 AM |
|
Mmanis -
You can step through the code to find the problem, but it could be eaiser to
make the field a required field in the Items table. Then wherever in the
code it is adding a blank record, it will error out - at that point you can
select the Debug option and then fix the code.
--
Daryl S
"mmanis" wrote:
> Hello, I have a form (frmpurchases) based on a query. My query is based on
> two tables. tblPurchases (master table) and tblItems (lookup table describing
> the item category). The field link between the two tables is the field
> called Items.
>
> On frmPurchases, there is a list box for selecting the type of Item. which
> once selected, autofills various other fields with the Items details.
> Everything seems to work fine and I have no problem adding records etc. The
> one glitch I can't figure out, is everytime I add a new purchase using
> frmpurchases and select the Item(list box), when I go out of the database and
> come back in, there is a new blank record in my TblItems for every new
> purchase I entered. So if I select the list box again, there will be blanks
> in the list for every new record.
>
> How can I prevent my lookup table from adding blank records with each new
> purchase.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/27/2010 2:31:02 PM
|
|
|
1 Replies
222 Views
(page loaded in 0.035 seconds)
Similiar Articles: How to add a blank column as text, number or currency - microsoft ...How do I add numbers across columns of a single record ... Split records ... How to Access a Query Add Column With a Blank Cell; How to Insert Columns Into Lookup Tables populate table using multiselect listbox - microsoft.public.access ...... save the current record if it's not ... Then ' add it ... Update table with Multi-select list box - microsoft.public.access ... populate table using ... Adding New Record to a linked table from Query - microsoft.public ...Is it possible to add a new record to a linked table from ... click on the new blank record ... Unable to update/add records in connected SQL Server tables ... Lookup long ... How to auto fill fields on subform from data on main form ...... if I make the datasheet use a lookup to the employee table, but then I have to select the employee each time I want to add a record in ... based upon a query from listbox ... Adding Data to a lookup column in a form - microsoft.public.access ...I have a lookup column I am using in form pulling data from table. When I add data into ... the NewData as a record in the Categories table. ... How to add a blank column as ... How to change existing table record value by VBA and How to add ...With VBA how can i lookup for value "SD001" in "Ticket_No" field ... How to change existing table record value by VBA and How to add ... insert record from list box to table ... How To Access From VBA A Tables Row Lookup Row Source - microsoft ...... using table lookup ... table record value by VBA and How to add ... With VBA how can i lookup ... Tables Row Lookup Row Source - microsoft ... Listbox row source and record ... Selecting Items From Listbox and storing into table - microsoft ...I am using a list box to pull back the names and ... Then if I enter data into the last record (which is blank), it adds ... Pass multiple selected values from list box to table ... populate list box programmatically - microsoft.public.access ...... tables are not linked. I'm using ADO to connect and retrieve records. I need to populate a list box ... or list box. ... How to populate a list ... do I add a blank record Why Does My Form Copy Values From My Lookup Box To The Other Recor ...One of the fields on the form is based on a lookup table for ... However, when I change the first record to a different ... formatted field in my query used for the list box show ... Microsoft Access tips: Adding items to a combo/list boxUse this event to add the new item to the RowSource table. ... Combo was blank, so go to new record. RunCommand ... Use these lookup tables (or queries based on them ... Add one or more records to a database - Access - Office.com... items in a lookup field; Enter zero-length strings; Add records by using the ... combo box and list box control, respectively. When you use a list in a table ... Click each blank ... How to: Insert, Update, and Delete Records From a Table Using ...There are essentially two methods for adding records to a table. The first is to add one record at a time; the second is to add many records at a time. In both cases ... Lookup table in Microsoft ACCESS - Trigon Blue Inc. - Microsoft ...Using lookup tables in Microsoft Access to ... can have more than one record in the Company table. It is possible to display a list box ... When you add a new record, it is enough ... Set default values for fields or controls - Access - Office.comBy default, list box ... box when you add a record to your database. Set a default value for a lookup list. Open the table ... in your lookup field when you add the record. Top ... 7/16/2012 7:14:26 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 