My form is showing a primary key

[Delta729]

So, I'm trying to redesign my database and I'm having problems. In the form {frmRegVenPO} and in the top subform on the page named {fsubRegVenPO} (the subform with the label Vendor. There is only 1 piece of data, that being the vendor. However, it appears to be showing a primary key.




I tried to change it to a combobox, and then that got all messed up for awhile. I'm back to where it appears to showing the primary key in a text box. (I had something like this happen the other day, but somehow I fixed that. However, I had trashed that db because I found that I was just not following good database practice, or at least to me it seemed that way.

Can someone tell me how to fix this. It seems to something about changing the control source to show column 2. But whenever I try that, it just shows me an error. Any help would appreciated. Thanks.

[ranman256]

all my forms show the primary key, do you not want it to show? If not, set it to invisible.

if you want to load the data by having user pick a primary key, then the combo box of keys CANNOT have a control source (bound to a field, so you dont alter the record key)
Once the combo box is unbound then user can pick a key, and load that record via AFTER UPDATE event:

Private Sub cboBox_AfterUpdate()
If IsNull(cboBox) Then
  Me.FilterOn = False
Else
     'if numeric
  Me.Filter = "[CompanyID]=" & cboBox 
     'if text
  'Me.Filter = "[CompanyID]='" & cboBox  & "'"


  Me.FilterOn = True
End If
End Sub

[June7]

The numeric values are from the Vendor field. Replace them with names.

If you are going to link these subforms on Vendor, there is no need for Vendor combobox.
Same goes for Region combobox.
Why even have these non-visible controls?

[mike60smart]

Hi

I removed all of the Lookup fields from your tables.

I added a table just to list the Vendors.

I only looked at the relationships between the Regions - Vendors and PO

In the Form that opens at startup you can do the following:-

1. Select a Region
2. Select a Vendor for that Region
3 Add PO Number and Date

Does this help?